Viewing 15 posts - 52,711 through 52,725 (of 59,070 total)
Jeff i think you don't wont to help
only make it difficult
you think i am don't know "how to make simple schedule" or bother you in purpose
you are insult me...
January 27, 2008 at 8:59 am
"GO" isn't actually a part of T-SQL and it can't be used the way you want in Dynamic SQL...
January 26, 2008 at 6:07 pm
So, why do you have to count down from the middle of the month and count up from that same date to the end. And, why does the secretary...
January 26, 2008 at 5:41 pm
Are you sure we're talking BCP 'cause BCP doesn't output column headers and can't be made to do so... it requires a UNION in a proc to output column headers...
January 26, 2008 at 9:11 am
How many rows are you loading with BULK INSERT?
January 26, 2008 at 8:43 am
Philip Barry (1/25/2008)
Is this principal of limiting the number of rows for the deletion operation also applicable to updating? I have to update several hundred thousand rows and I...
January 26, 2008 at 8:06 am
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
Viewing 15 posts - 52,711 through 52,725 (of 59,070 total)