This whole thread and the original concept isn't something I would even consider doing... First, there may be a GUI out there that you don't know about that requires those...

No, it's not possible using BULK INSERT.

Ray, the title of your post hit the nail on the head... get rid of the cursors, plain and simple. I'm not...

... and PLEASE DON'T DOUBLE POST!!!!

http://www.sqlservercentral.com/Forums/Topic436570-338-1.aspx

... and PLEASE DON'T DOUBLE POST!!!!

http://www.sqlservercentral.com/Forums/Topic436572-338-1.aspx

The REAL question would be, WHY are you using a cursor for this? You should be able to do this in a setbased fashion...

have about 2,00,00,000 records in a table which are being queried.

More over I have 2 more tables of same specs mentioned above.

Queries are taking lot of time. usually...

Heh... I got the answer right but the real answer isn't one of those listed. The question is "What must he worry about when using the @@FETCH_STATUS function in...

Ok... another way to do it would be to export the data to tab delimited files on some common file share and use BCP or BULK INSERT to import the...

Dunno about most... I'd simply make linked servers and have a proc read the data in. Don't want to make a single view because if one of the servers...

Heh... a While loop... "Firehose" cursor would be just as good... take a look at the function I made in this thread... no explicit loop... no cursor... still basically hidden...

Hi Mark,

It's just the way this forum handles things when they repost an article... no updates were actually made.

Ion Freeman (12/28/2007)

---

The whole reason I don't write articles like this is because I don't want to do the heavy lifting around collecting metrics. So, I'd like to see that...

Heh... yeah... then there's that...

sorry Jeff I have to disagree, even if the clustered index is on an indentity column then the clustered index is actually the entire table, regardless of the index being...