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

More people need to know about the method that Dave showed in this article.

On modern machines, we still get 3 orders of magnitude difference in CPU and Duration (shown...

I did?  I don't remember... I've gotten old enough where I think my harddrive is full and, every time I learn something new, either something else in my mind...

It would be interesting to see...