Viewing 15 posts - 56,386 through 56,400 (of 59,069 total)
Sorry Gail... operating on my first cup of coffee
Do you have the URL for that?
--Jeff Moden
Change is inevitable... Change for the better is not.
May 18, 2007 at 7:19 am
I share the same thoughts. You've certainly got the right idea about improving your own skills. Even though I've been doing this for a while, I still learn new things...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 18, 2007 at 7:16 am
Heh... Wasn't going to say anything about that so it wouldn't change anything but, I absolutely agree, that's normally a prime give-away. Another dead give-away is the level of urgency even if...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 18, 2007 at 6:49 am
I'll be the first to agree with making the end result pretty... I'm just not sure why they don't do that at the presentation layer... or, maybe that's the problem? ...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 18, 2007 at 12:01 am
Heh... nice job Serqiy... guess I didn't have enough coffee
I didn't think of the crosstab-like solution. Very cool.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2007 at 11:57 pm
Hmmm... I'm using SQL Server 2000 sp4 Developer's Edition and it works fine...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2007 at 11:54 pm
Heh... THAT would be funny, indeed. Thanks, Antares...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2007 at 8:44 pm
My pleasure, Maqy... thank you and James for the feedback.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2007 at 7:07 pm
You don't need to archive as an "Excel" file... just export it as a Tab delimited file and reimport if you need it.
If you don't have SA privs, BCP would...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2007 at 6:12 pm
Simple, elegant, and nasty fast, James. Well done...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2007 at 6:09 pm
If you use BCP along with the "Simple" Recovery Mode on a staging table with no indexes and no triggers, the load of 150,000 rows should take no more than...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2007 at 6:06 pm
Thanks for the feed back James and Nickie...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2007 at 5:54 pm
Oh yeah... absolutely. That's part of why I was asking... Not having a PK on the table really seems dumb. And, I absolutely agree with Marty on this one... the...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2007 at 5:52 pm
That's what I'm talking about
Once we know what you need, Jan, lots of folks have great solutions to avoid the cursor. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2007 at 7:33 am
You've missed the point, entirely, and I doubt you have any real understanding of the solution. Good luck, "sir"... you will need it.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2007 at 7:26 am
Viewing 15 posts - 56,386 through 56,400 (of 59,069 total)