Hmmmm... that just made me realize that we're all forgetting something.... none of the SELECTs, so far, expose the Primary Key. 

I thought you said you have an app that will do the encryption of new data that goes into the table... I thought that maybe you could "trick" it into...

Yep... that would do it... that was the only 1 of the 3 that I did look at.  Thanks, David.

Jack,

It appears that you want to convert the dd/mm/yyyy format in which case, the examples posted, so far, will reject a large portion of your dates.  If that's true,...

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