Step 1, I think, (normally not so adamant) would be to make sure that whoever designed this mess needs to be identified, captured, disemboweled in public, and have his/her...

Ok... so why can't you use the application to encrypt the data on a "one time basis"?  Sorry, Dinakar, I just don't understand why this is a problem.

What ever are you talking about?  There is no ISINTEGER function in MS-SQL Server....

IsNumeric allows anything that can mathematically be converted to a numberic value including scientific notation (e), decimal...

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...