So test the values of @startdate and @enddate to make sure that they're both  >= DATEADD(yy,-1,CONVERT(DATE,GETDATE())) and pop the message if they're not.

Ok... After a year, I'll take that as a "No". 😀

From what I read, and think I understood, this code is creating a watchdog that looks for SQL statements that contain the "Having" clause. When it sees that clause,...

Not to worry... I've been bitten by that type of...

I don't understand what you're saying here.  Is the STRING_AGG() solution working for you but...

BWAAA-HAAA-HAAA!!!  I have the "Change is inevitable" quote in my signature line below.  I found its brother today quite by accident that covers what you went through, ZZ...

"If it's not...

As a bit of a sidebar, your #Message table shouldn't exist in a normalized database.  The MessageValue appears to be an aggregation of voltages related to the combination of the...

What I'm amazed about is the attitude surrounding software projects especially from large companies like MicroSoft.  What ever happened to the idea of "Putting your best foot forward" instead of...

At the risk of 'negative feedback' I'll add that after a couple years, I still get the error rejecting my first post effort with "Did you really mean to...

p.s.  Here's a higher risk method of doing the same thing.  It's higher in risk because it uses CheckSums instead of the "full monty" like we did with the String_Agg()...

• This reply was modified 3 years, 4 months ago by Jeff Moden.

Ok... it took me a minute to figure out what you were asking for and I'll assume that what I stated above is correct.

The following code will do the trick.