Viewing 15 posts - 57,781 through 57,795 (of 59,054 total)
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...
August 23, 2006 at 5:30 pm
Yep... that would do it... that was the only 1 of the 3 that I did look at. Thanks, David.
August 23, 2006 at 6:53 am
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...
August 23, 2006 at 12:17 am
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.
August 22, 2006 at 11:14 pm
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...
August 22, 2006 at 11:02 pm
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?
August 22, 2006 at 6:32 am
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...
August 21, 2006 at 9:16 pm
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...
August 21, 2006 at 8:45 pm
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...
August 21, 2006 at 8:39 pm
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...
August 21, 2006 at 7:46 pm
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...
August 20, 2006 at 10:21 pm
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...
August 20, 2006 at 11:19 am
Be careful... IDENT_CURRENT is not scope sensitive and, if someone else did an insert, may not reflect the row that your proc inserted.
August 20, 2006 at 11:15 am
Viewing 15 posts - 57,781 through 57,795 (of 59,054 total)