Viewing 15 posts - 54,361 through 54,375 (of 59,072 total)
Hi Tod,
Still would like to know what the CLR does (general explanation would do) because there's a lot of times when folks will write a CLR instead of doing it...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 2, 2007 at 8:29 am
I guess my first question would be... what does the CLR do?
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2007 at 9:45 pm
??
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2007 at 8:39 pm
Ack... agreed... I missed that... not enough coffee... :hehe:
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2007 at 8:19 pm
Not sure I'd waste my time benchmarking for that...
Why not just Google a bunch of articles about SQL Server Maintenance... lot's of them say "why"...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2007 at 5:27 pm
It doesn't... from the way you were talking, I thought you were using a "blank formatted" spreadsheet file as a template that you copied for new files.
What are you currently...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2007 at 5:22 pm
Nice 2k5 solution... but I'm pretty sure that it won't work in 2k... 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2007 at 5:15 pm
What in format 1 identifies which column something should go into in format 2? Also, please describe the column names in format 1... I don't think they start off...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2007 at 4:56 pm
SET ROWCOUNT can sometimes be a lot slower than TOP... if it turns out to be too slow, you could always use dynamic SQL (observing, of course, all the warnings...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2007 at 4:52 pm
Change the spreadsheet template to have a "freeze panes" in the correct spot.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2007 at 8:19 am
VBS MsgBox from Cmd prompt...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 31, 2007 at 8:46 pm
Close! Not seeing StockCode 12 anywhere in the result, though...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 31, 2007 at 1:47 am
Parts or people, it's still a hierarchy... take a look at "Expanding Hierarchies" in Books Online... they've got a decent example. There's a couple of other ways to do...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 30, 2007 at 5:48 pm
The only way to guarantee the same time would be to store it in a variable and then do the SELECT using the variable instead of GETDATE().
--Jeff Moden
Change is inevitable... Change for the better is not.
October 29, 2007 at 9:18 pm
Yeh... 2nd mistake today... 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
October 29, 2007 at 9:12 pm
Viewing 15 posts - 54,361 through 54,375 (of 59,072 total)