Seems to work. Used two databases here:

Results are :

1 X

2 NULL

USE compare2
GO
CREATE TABLE TriggerTest (myid INT, mychar CHAR(1))
GO
CREATE TRIGGER tri_triggertest ON  dbo.TriggerTest FOR INSERT
AS
BEGIN
  ...

Indexing would be the only way I see to make this faster. Whether you use a CASE or Phil's solution, I wouldn't expect one to be appreciably faster.

I did an...

I'd wonder as well if there were some personal connection or perhaps some other non-business reason.

The only reason most people care about where you are in the cloud is governance....

Thanks, a data migration issue. I'll log this.

A related problem I see is that they know where the data is, but the same data is in so many different places there is no understanding of what...

• This reply was modified 3 years, 4 months ago by Steve Jones - SSC Editor.

I'm remembering SQLSlammer.  Many SQL shops got caught out even though they had patched every SQL Server they knew about.

It was the MSDE instances they didn't know about that...

It's not even mundane things. I see some orgs that sell to other businesses and give them trials or PoCs with live data. When those companies move on without being...

That is does. Especially with all the self-services stuff in many orgs.

I think this was a place where either a redirect was incorrect or the post should have been edited.

I've manually updated the link for this one.

I think the biggest challenge, as you allude to, is the effort to track and ensure this stuff is handled well. I've been concerned about the restore/replay issues, and ensuring...

The default is NULL for columns if not specified...

Yeah, lots of people like typing. Esp technology people

Michael has some good ideas, but what I'd do is not run this on a huge table. Get 20-30 rows and work out your logic and query. Then look at...

Access works.

Best to start a separate thread for this, so people can find the answer.