What does the trigger do?

Can it cause conflit?

What's special about this task??

He wants to make an omelette without breaking eggs... can't wait to see that solution .

Look at my post count, I answered and solved over 2000 problems. I paid 15K to get my formation (1 500 hours) and it took me over 6...

and isnull(a.LocationID) = isnull(b.LocationID)

Maybe this is one case where I would try to avoid the nulls by putting a default value, as this solution will slow down the query (by...

Have any dead lock on tempdb or maybe a filegrowth of tempdb?

Do you have autoshrink or auto-close set on any of the dbs on that server?

Dude, get a book and learn, this isn't a school for newbies. We don't mind helping but we actually paid and worked to get our formation.

This is the best...

When is that (sorry never had that happen to me)?

W3Schools - SQL

Told ya you had to do a few next .

Select Cols from dbo.Table1 T1 RIGHT join dbo.Table2 T2 on T1.id = T2.id and T1.date_x = T2.date_x

where

T1.id is null

Yeah that's gonna happen, ask microsoft if they will send it to you . You won't get that from here.

You're right, but if I had a slow running query and that potential problem, the slow running query would be handled first... and then maybe that one (unless this is...

Also that old saying : "If it ain't broken, don't fix it" .

Never said it was you who said that either .

Please read this, there are a lot more pitfalls to dynamic sql .

The Curse and Blessings of Dynamic SQL

And please...