Viewing 15 posts - 57,781 through 57,795 (of 59,048 total)
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
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...
August 19, 2006 at 11:42 am
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...
August 19, 2006 at 11:36 am
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...
August 19, 2006 at 11:10 am
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...
August 19, 2006 at 11:01 am
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...
August 18, 2006 at 9:50 pm
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. ...
August 18, 2006 at 9:27 pm
Viewing 15 posts - 57,781 through 57,795 (of 59,048 total)