It’s funny nobody suggested the most obvious choice in such situation - RIGHT JOIN:

Select s.Shipment_No
     , p.pkg_no
     , p.ord_no
From...

• This reply was modified 3 years, 3 months ago by  Sergiy.

You should use [inserted] table instead of dbo.[TorpedoVision Data 2021] inside of the trigger.

and don't send emails from triggers. Insert the data to be sent into a "queue" table and...

Empty string (not NULL, empty string) of XML data type takes 9 bytes.

Single character XML occupies 13 bytes.

Every extra character takes extra 2 bytes.

Therefore, the clus index on the dbo.order_items should be ( order_id, $IDENTITY ) and not just ( $IDENTITY ).  Since the parent key is sequential, this...

Therefore, the clus index on the dbo.order_items should be ( order_id, $IDENTITY ) and not just ( $IDENTITY ).  Since the parent key is sequential, this key will be...

OK then.

My recent experience with "flat-earthers" taught me that it's almost useless trying to prove anything to...

Unfortunately, that actually proves that they don't know.  Bob Ward is still talking about the use of reorganize for...

OK then.

My recent experience with "flat-earthers" taught me that it's almost useless trying to prove anything to true believers....

OK then.

My recent experience with "flat-earthers" taught me that it's almost useless trying to prove anything to true believers. For them...

That's a...

Don't forget: Microsoft is a Cloud Service provider. Quite a big one. With no plans of retreating.

Increased load on in-house servers makes the argument for a company to move to...

Yeah, that's an issue with working from home - the reliability requirements...

https://docs.microsoft.com/en-us/dotnet/api/system.guid?view=net-5.0

Check ToString method, the option with Format in it.

you might find some formats not using dashes. The one with semicolons is quite popular.

Ni, it's not.

even the order of parts may be different depending which application converts that binary(16) to a character string with dashes.

I suggest creating the following indexes to support the query.  If you'd like to adjust other indexes on the tables also, just let me know.

CREATE UNIQUE...