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

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 1 years, 5 months ago by Steve Collins.