Viewing 15 posts - 52,711 through 52,725 (of 59,064 total)
Matt is spot on... rewrite the insert code to be set based instead of RBAR.
January 26, 2008 at 7:51 am
Would you mind posting it here so the rest of us might benefit? Thanks...
January 26, 2008 at 7:50 am
What is it that you want to do if there a rows that have changed between Inserted and Deleted? Perhaps insert into an audit log?
Then, ya gotta think in...
January 24, 2008 at 8:37 pm
Looks like a nice tip... probably meant to post this under "scripts".
Thanks, Pete.
January 24, 2008 at 8:28 pm
the BUG
on date '15/03/2008' the shift must start with 8
on date '12/03/2008' the shift must start with 8
on date '11/03/2008' the shift must start with 8
WHY? Why do you...
January 24, 2008 at 5:02 pm
Yeah- huh? I spent most of my school years in Rhode Island... I know what you mean.
Good luck and thanks for the feedback!
January 24, 2008 at 4:31 pm
That was not rude...I acknowledged the efforts of each and every person who contributed to my post.....
No, it's downright rude when you post the same question on 10 different forums...
January 24, 2008 at 4:28 pm
Just an FYI... The original design wasn't bad... 2nd normal form table...
January 24, 2008 at 8:05 am
Emmanouil Karaiskakis (1/24/2008)
I don't know what to say? Thanks a lot for all the support!!! I'm overwhelmed!!!
Just to let you know, I won't be using DTS/SSIS packages for this...
January 24, 2008 at 6:09 am
I obviously need more coffee... Adrian, who was that last post of yours directed to?
January 24, 2008 at 6:06 am
Dang... you wrote an article on it, they published it, and they still don't get the hint???
By the way, the "bad" character is actually a CHAR(11) or "Vertical Tab" in...
January 23, 2008 at 8:39 pm
Whitt (1/23/2008)
Really sorry for the delay. I'm being shifted from fire to fire here. I haven't had time to run this as I've been moved to helping with...
January 23, 2008 at 8:31 pm
We'll I'll be... just tried the CTE equivelent of how I build Tally tables (NO, NO RECURSION PLEASE! 😛 ) on the same example data... it does surprisingly well! ...
January 23, 2008 at 8:20 pm
I gotta agree with Kenneth... and, I'll throw in that CPU time matters as well. I thought the example code I posted that didn't use a Tally table would...
January 23, 2008 at 7:40 pm
Not only should you get the BIG Manager to put it in writing, but you should make a full backup of the 4 system databases, which includes the Master database,...
January 23, 2008 at 6:54 pm
Viewing 15 posts - 52,711 through 52,725 (of 59,064 total)