Viewing 15 posts - 2,911 through 2,925 (of 4,080 total)
Give a man a fish and he'll eat for one day...
Slap him around with a trout, and he may go away and leave you alone.
Wait around long...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 3:09 pm
Cross Apply or Outer Apply will work.
-- Whups, just realized Mark already submitted this solution.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 2:53 pm
update table2
set maxID = (select max(ID)+1 from table1)
--
Are you intending to put this in a trigger or what? That seems like a lot...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 2:34 pm
You're welcome, blake. Good luck to 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
April 28, 2009 at 2:31 pm
You know, I guess it is really hard to teach someone fish when you are in the middle of the desert...
Somewhere that man is getting well paid for the use...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 2:25 pm
GETDATE() is a function. You have to include the parens after it.
[dbo].fn_AddBizDays(GETDATE(), 1)
Be advised that GETDATE includes the current time as well as date, unless fn_AddBizDays strips it...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 10:44 am
Understood.
Just make sure you're covered when they finally notice that they can't depend on the sequence. 😉
One other thought. In 2005 and...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 9:27 am
This is actually a "recommended practice" at my current employer
Gus, I have such mixed emotions on reading that....
On the one hand I sympathize and empathize. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 8:46 am
Consider what is supposed to happen if you have concurrent transactions going on.
1. Transaction A inserts, which produces identity value 100.
2. Transaction B inserts, which produces...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 8:41 am
Welcome back, Roy. It's good to see you again.
Paul, a few of the articles out there may be weak, but sometimes the discussion posts turn out to be...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 6:37 am
Sorry to leave this hanging so long. 🙂
I went the same route as Andrew, adding a @model table variable to go with @skl_skill to control the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 27, 2009 at 9:23 pm
Send me the link you have for that in BOL, please.
I took a quick look and found that you can use this format when you EXEC a UDF.
Don't know if...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 27, 2009 at 8:25 pm
"Thank you"s are indeed payment. I stand corrected.
You are welcome, Scott. We'll look forward to hearing from 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
April 27, 2009 at 3:37 pm
Thanks 🙂
Loading it up, 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
April 27, 2009 at 2:59 pm
I can't find it in BOL, but I think you're SOL. 😉
Best you can do is this, and it still means keeping the positions of the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 27, 2009 at 2:49 pm
Viewing 15 posts - 2,911 through 2,925 (of 4,080 total)