If any consecutive click within 2 seconds is sufficient then the query posted looks ok 🙂

The query...

• This reply was modified 10 months, 3 weeks ago by Steve Collins.

Instead of typing up an example I pasted your code next to a table from another topic and then did cut/paste/replace the column names.  "...ts.PKey is not column of subquery"...

• This reply was modified 10 months, 3 weeks ago by Steve Collins.

your are right: using a qualifier results in an error (unknown column):

update TempSel set WertA = 'TEST' where PKey in 
(select Q1.PKey from (select PKey as...

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