Viewing 15 posts - 54,361 through 54,375 (of 59,067 total)
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...
November 1, 2007 at 5:22 pm
Nice 2k5 solution... but I'm pretty sure that it won't work in 2k... 😉
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...
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
Viewing 15 posts - 54,361 through 54,375 (of 59,067 total)