I think this approach relies on data quality that isn't necessarily guaranteed.  For instance, if the two statuses were "Presentation" moving to "Approve", the LAG() method would catch it,...

LAG, which compares rows within the window partition, is not strictly necessary imo.  JOIN relates to a lookup table containing the values sequence.  Also, I'm not a fan of ordering...

> What difference the client is a phone? <<

Because to determine all the Tests that haven't been fully graded could require scanning a very large number of StudentGrade rows.

If,...

Thanks for getting back to me.

I have always been hesitant to use a flag in one table when I could get that same information using a database query. Since...

To maintain each country's local time, we have collected their respective time zones. Initially, everything worked fine. However, as time passed, some countries requested changes to their time zones...

Hi pietlinden, maybe you want to generate random prices for a base price of 50, plus or minus 5.  Or maybe you want a base price of 50, plus or...

You're already generating a series using dbo.fnTally so maybe raise fn.N by an exponent power.  Either POWER or EXP function

declare @increase_pct      ...

Yes so I went with 2 queries.  Just because it's possible to jimmy horn different sets in the WHERE clause doesn't mean it's a good idea

Alternately

with rn_cte as (
    select pv.PatID, pv.AcctID, pv.ProcDate, 
           iif(v.abs_diff>=2, null, dv.Department) Department, 
...

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

The query...

• This reply was modified 3 weeks, 6 days 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 4 weeks, 1 day 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...