Yes, definitely.  That's another reason I wrote the trigger that way, to allow sample value(s) to be pulled for use in the email, if needed.

For example:

DECLARE @min_number_of_entries_expected...

Or take the month difference and divide by 12.

Create a job to check on the data.  Even though it will check the last hour, you could schedule it to run as often as you wanted to check:

            
January 7, 2021 at 5:14 pm
            
#3828658

            
            
                                                
        

My first thought would be to simply take the difference of the year.  Do you want to adjust based on the month as well as the year?

SELECT...

• This reply was modified 5 years, 2 months ago by ScottPletcher.

I don't see any view defs.  Instead of attaching them, you can post them using the "insert/edit code sample" button when you go to post a Reply.

If I'm overlooked them...

If you have some indexes that have woefully low (less than 80% average percent of page fullness [page density]), then rebuild (NOT reorganize) them at 82%...

If you have some indexes that have woefully low (less than 80% average percent of page fullness [page density]), then rebuild (NOT reorganize) them at 82% to recover the...

 

SELECT a.cardnumber, Count(*), Sum(AMT) 
from transactions a
where Merchant like '%Google%' or Merchant like '%Microsoft%'
group by a.cardnumber
having max(case when Merchant like '%Google%' then 1 else 0 end) =...

here the fieldName 'Status' is 'On' AND filedName 'Subs' isn't 'No' ... only mach 1 would be returned

But for mach 1, the value for Subs is 'No' in your sample...

If you want round up the avg to whole seconds, then you can use CEILING.  If you want to round to a certain number of decimal places, use ROUND.  In...

Good observations. The view, like this query, is a mess. It joins 7 tables, including one in a database on another server with a different collation, and another view....

Can you post the query for the view being referenced?  At least I'm assuming that "vwRequests" is a view.  I can't tell what indexes might help this query without seeing...

cast(

case f.HAI

when 'A' then (isnull(f.NUM,0)/f.DEN) *10000.00

when 'B' then (isnull(f.NUM,0)/f.den) *1000.00

when 'C' then (isnull(f.NUM,0)/f.den) *1000.00

when 'D' then (isnull(f.NUM,0)/f.den) *1000.00

when 'E' then (f.NUM/f.den) *100.00

else 0.00

end as decimal(9, 2)) as 'Rate'

If you're joining to the table, and it currently has no indexes at all, then create a clustered index on the WHERE columns and/or JOIN column(s).

To give you anything more...

Please be aware that this is forum for SQL Server dbms.  Your code is obviously for a different dbms.  You might get a better response if you post on a...