Viewing 15 posts - 1,246 through 1,260 (of 4,080 total)
Unless the table has a defined IDENTITY column, or you've come up with your own sequencing scheme, the system has no way of magically tracking which rows were inserted last.
Even...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2010 at 5:09 pm
Let's make sure the logic is working as expected first.
Try adding a little debug code just before you send the email. Write out...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2010 at 2:54 pm
I believe you are confusing EXEC @sql with "parameterrized dynamic SQL" which requires that you EXEC sp_executeSQL.
If you want to use EXEC by itself,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2010 at 2:50 pm
Nyuck, nyuck, nyuck.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2010 at 2:45 pm
Jeff Moden (12/6/2010)
The Dixie Flatline (12/6/2010)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2010 at 2:41 pm
If I understand you correctly, you always want the start and end dates from the prior month, regardless of the starting and ending date that you provide. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 6, 2010 at 10:53 am
To all the people in the U.S.: Have a happy Thanksgiving.
To everyone else. Have a happy Thursday. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 24, 2010 at 3:31 pm
Yes, it will mean less space and better I/O.
As has been pointed out, this approach makes you responsible for remembering to divide by 10 forever. If you...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 24, 2010 at 9:10 am
I can't get this out of my head now.... and I can't stop myself from posting this.
Instead of vuvuzelas for soccer, fans could start carrying bokkens to rugby matches in...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 19, 2010 at 10:01 am
GilaMonster (11/18/2010)
CirquedeSQLeil (11/17/2010)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 18, 2010 at 3:49 pm
Paul, thanks for the reply. I understand now.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 12, 2010 at 7:44 am
Paul, I ran the code and saw the log entries, but I wasn't doubting his word.
Let me rephrase the question: What is the purpose...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 11, 2010 at 10:27 pm
You're very tiny! (j/k)
Nice shades though...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 11, 2010 at 10:24 pm
Congratulations, Wayne. Applause! Thunderous applause
Let me ask what logging takes place with table variables, since they are not affected by rollbacks.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 11, 2010 at 9:43 pm
I'd be happy to Jason, if you will include a picture of what you look like.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 11, 2010 at 9:27 pm
Viewing 15 posts - 1,246 through 1,260 (of 4,080 total)