Viewing 15 posts - 54,361 through 54,375 (of 59,065 total)
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...
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...
November 1, 2007 at 4:52 pm
Change the spreadsheet template to have a "freeze panes" in the correct spot.
November 1, 2007 at 8:19 am
Close! Not seeing StockCode 12 anywhere in the result, though...
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...
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().
October 29, 2007 at 9:18 pm
OH! How embarassing... I thought you were talking about "LDF's"... sorry...
October 29, 2007 at 5:39 pm
Kenneth Wilhelmsson (10/29/2007)
October 29, 2007 at 5:35 pm
BaldNomad (10/29/2007)
you're validating data that's already been validated? why?
According to the OP, the data is in a file... much like storing dates as datetimes, I always valid even supposedly...
October 29, 2007 at 5:32 pm
mrpolecat (10/29/2007)
Jeff--It throws errors
Server: Msg 156, Level 15, State 1, Line 27
Incorrect syntax near the keyword 'ASC'.
Server: Msg 208, Level 16, State 1, Line 12
Invalid object name '#yourtable'.
It's gotta be...
October 29, 2007 at 5:29 pm
In MS Word...
{Edit}{Paste Special}{Unformatted Text}
October 29, 2007 at 5:23 pm
Greg,
Lot's of folks keep a bit of handy test table code around for these types of tests. It's built using the same method I showed you to build a...
October 29, 2007 at 7:06 am
And, you've validated the dates how?
I normally don't say "never" to anything... but this would be one of them.
October 29, 2007 at 6:48 am
Viewing 15 posts - 54,361 through 54,375 (of 59,065 total)