Viewing 15 posts - 41,386 through 41,400 (of 59,067 total)
I've seen this exact same problem a couple of times over the years... and it was homework for a course. Please show what you've tried and if you still...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 11:35 pm
Ashok Nalam (10/22/2009)
So it has basically start from ( based on configuration by customer specific) to end time then start time onwards.
It depends... where is the "configuration by customer specific"...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 11:26 pm
You can't use BCP with parameters unless you turn it into dynamic SQL.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 11:22 pm
Thanks for the kudo, Lowell.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 11:09 pm
I missed this before, Flo... it's written well enough that it probably should have been an article. Well done.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 10:48 pm
Heh... "It Depends".
It all depends on how you load the data (ie: IDENTITY_INSERT) and whether or not an IDENTITY column is even needed. I don't see an IDENTITY column...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 10:43 pm
Sorry... I just haven't gotten to this one, yet. Do you still need help on it?
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 10:18 pm
Steve Jones - Editor (10/22/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 10:16 pm
All right, Brad... I looked at all of this and, although I return what you wanted, I got carried away. If it were me and I saw some of...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 10:05 pm
Steve Jones - Editor (10/16/2009)
If I understand, what you likely want to do is use a CASE statement for...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 9:57 pm
The only thing that remains if for you guys to tell us a fool proof way to find a good local tuner. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 7:27 pm
Also, the book is right... change everything in the format file to SQLSCHAR and ad more column width... anything that's an INT should be set to at least 10, not...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 7:24 pm
I'd recommend that you take another look at Books Online for how to skip columns. You can't just skip them by leaving them out no matter where they are...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 7:22 pm
I see it's your first post on SSC... Welcome aboard!
Again, as with many of the other posts, that does the whole table. If that's what you want, then you're...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 7:13 pm
Thanks, David. Coming from someone with your background, that's a great compliment.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2009 at 6:56 pm
Viewing 15 posts - 41,386 through 41,400 (of 59,067 total)