Viewing 15 posts - 43,036 through 43,050 (of 59,063 total)
hi_abhay78 (7/7/2009)
-> Create a cursor that inserts the values from you main table to the temp table...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 6:39 pm
Garfi61416 (7/7/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 6:35 pm
Drew,
I am actually in the process of writing a book on the subject and thought I'd ask... why did you think you needed a cursor for this problem? I'm...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 6:29 pm
Lynn,
If someone runs this against something that also has a time element in the date, won't there be a problem because of the BETWEEN?
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 6:25 pm
GSquared (7/8/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 2:46 pm
roelofsleroux (7/8/2009)
- Most find it more readable and different object stand out from queries.
I'm sure you can produce a white paper on the multitude of opinion polls that substantiates...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 2:42 pm
mckinnj1 (7/7/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 2:34 pm
ali.m.habib (7/8/2009)
Jeff Moden (7/7/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 6:31 am
Eswin (7/8/2009)
SET @bcpCommand = 'bcp " select '''+ @expFile +'''" queryout "'
SET @bcpCommand = @bcpCommand + @exptionFile + '" -T -c'
EXEC master..xp_cmdshell @bcpCommand
i don't think you can use '+'...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 6:29 am
WayneS (7/7/2009)
Lamprey13 (7/7/2009)
This will probably work, but you cannot guarantee that it'll work based on the PK order.
Thanks for pointing that out... I've edited the post to include the necessary...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 6:07 am
Heh... do you expect it to guess what to do with your stored proc? You need it to be a valid query.
Also, (local) doesn't seem to work as a...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2009 at 9:04 pm
rpyerneni (7/7/2009)
I worked on your code. As I told you I have so many links in the content. I splitted the content and inserted the splitted data into a temporary...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2009 at 8:54 pm
I've never experienced BCP being slow at anything. Usually, it's the associated query that's slow. Please post both the BCP command and the query being executed by BCP.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2009 at 8:49 pm
Paul White (7/7/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2009 at 8:42 pm
Alvin Ramard (7/7/2009)
I don't think anyone mentioned:50 Ways to Leave Your Cursor (Paul Simon)
Here's another one where a name change isn't actually required to still be appropriate...
The good, the bad,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2009 at 8:31 pm
Viewing 15 posts - 43,036 through 43,050 (of 59,063 total)