Or what's the question?  It seems the topic's scope has crept after solutions were posted

So far I'm not seeing a solution for which each character returned is an...

"This table does not have any index and tigers. It has only PK."

The FROM and WHERE clauses of the INSERT:

FROM [DLSTYTOTAL] STG Left Join [TOTAL_RAW] TGT ...

Or a TRIGGER.  This is the sort of situation where one could be appropriate imo

Yeah, it's not clear.  The next sentence implies only 102 needs to be "printed" out.  I'm picturing one of those giant dot matrix line printers that used to fill up...

Hmmm... Phil's query returns 1 row (Rownr=7) for ItemId=102.  The topic says: "If the status is not in this order for any item then we need to print such items." ...

It's as popular as ever but I've always found JavaScript difficult to work with.  With JavaScript it's like you're inventing everything whereas with SQL and other languages it seems more...

If the ID is unique then yes DISTINCT would do nothing.  I was sort of thinking right-to-left if there were duplicate properties there could also be duplicate ID's.  No data...

My guess is to copy Drew's query but with DISTINCT in the outer SELECT

????

Begin tran of stp A

Stp B   - Insert record in table 1 --> fetch cross DB data --> insert records in table 2 --> insert records in table 3...

What is meant by more call dates and edge cases?  Does each [Call Date Start Date] always get split into 2 rows?  [Call Date Start Date] is an unfortunate name...

This topic has kept working away in the back of my mind.  It's made me wonder what it would actually take to set up a really good 'set based' backend...

If you alter the collation at the database level it can have a negative impact on many, many things including query results, query performance, backups, indexes, data integrity, and can...

Well I wouldn't want to make any recommendations in this regard.  Changing collation on an entire db could cause major issues.  If possible maybe set up a new instance with...