That's a nice looking query Ken.  The OP's query used "SELECT ... INTO #TEMP1" which could be a bottleneck to a larger process imo.  Of course, it's not possible to...

Scroll up a few posts and see Ken McKelvey's reply.  Once t_stamp has been converted to...

Well, I admit I've never used NOLOCK in a query.  There hasn't been any project where NOLOCK is/was clearly required.  The article doesn't actually put forward any performance metrics or...

Yep, t_stamp stored as BIGINT could be converted to DATETIME2(3). ...

Or the paradox is an enigma wrapped in a riddle.  The article is based on a musing which is factually unconfirmed.  Or maybe I missed the convincing part(s)

Ah ok, this is more correct.  My...

Okay I can easily see how to update a table field after an Insert but do I use the system Inserted when creating a trigger to update a field...

with rn_cte as (
    select l.*, v.gt_one, 
            row_number() over (partition by Number...

The queries so far don't identify the ranges of consecutive "greater than one" rows.  This query uses two ROW_NUMBER functions which both count up across PARTITION BY Number.  To reset...

Is CostKey unique in the CostKeyDeletes table?  If so then making it the CLUSTERED key would be preferable.  To log the process you could add an OUTPUT clause to the...

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