It's simple... >''

Wouldn't it be easier to spend a little extra money to buy a tool that does it in SQL Server instead of playing around with text files and all?

Nicely done, Ram.  The only problem is that the first sequence number comes out as -000 instead of -001 as the original requestor posted.  However, that's an easy fix because...

Had a similar situation and went with the same as your option 1... good thing, too.  We replaced the code for job 1 keeping the same schedule, changed the schedule...

I can't take the credit for this one but can't remember who first did it on this forum... it's the fastest "Missing ID" finder I've ever seen... all I did...

Rather than trying to BCP directly from a 200 Million row table (with or without the view for the mod), why don't you simply do a SELECT/INTO with the correct...

The QuestNodeUID made this a real pain in the hiney... the following is a complete test showing what you want... this has a "limited" range of hierarchies but will probably...

I just posted a similar solution at the following URL

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=302356

look for the function I created...

Be careful... IDENT_CURRENT is not scope sensitive and, if someone else did an insert, may not reflect the row that your proc inserted.

Steve,

I was being sarcastic with the person who made the suggestion of a copy editor... that's why I quoted "obvious"... You did great, as usual...  in the spirit of this...

I'll add to Serqiy's suggestion... there's a group of views called "INFORMATION_SCHEMA" that you might want to lookup in "Books OnLINE" (BOL).  They don't always contain all the info you...

p.s.  Just in case anyone asks...

A function, like this one, should never be used to populate a permanent table because of Normalization Rules.  It can, however be used to populate a...

Like this... (self supporting test includes function creation, test data creation, and demo of how to use the function).

--=========================================================

--      Create the function to do the concatenization

--=========================================================

--===== If the...

Actually, this is the 4th identical post  If you're not happy with an answer, please say so within the same thread instead of posting...

Please, please, please buy a book if you want good copy.  Poor grammar and typos missed by the spellchecker have nothing to do with reducing the utility of useful articles. ...