And bring us... a shrubbery!!

NI!

Shhhhh....

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...

Cross Apply or Outer Apply will work.

-- Whups, just realized Mark already submitted this solution.

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...

You're welcome, blake. Good luck to you.

Somewhere that man is getting well paid for the use...

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...

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...

Gus, I have such mixed emotions on reading that....

On the one hand I sympathize and empathize. ...

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...

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...

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...

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...

"Thank you"s are indeed payment. I stand corrected.

You are welcome, Scott. We'll look forward to hearing from you.

Thanks 🙂

Loading it up, now.