Thanks Lutz, that was perfect.

Many Thanks,

Phil.

Update: Code removed.

Thanks to all those that took time to review.

Phil.

Fair point, working on it 🙂

Phil.

Thanks.

Hi. That should work. My query is quite simple SELECT COUNT(UserId) FROM Table. How would I implement the email being triggered to a specific email address.

Kind Regards,

Phil.

Thanks for the response. Still use a trigger?

Kind Regards,

Phil.

Thanks John.

Hi Chris. I had an old image of my laptop so I used this.

Regards,

Phil.

Log records the following:

Microsoft SQL Server 2005 9.00.1399.06

==============================

OS Version : Microsoft Windows XP Professional Service Pack 3 (Build 2600)

Time ...

Hi.

I said not everyone would agree with my approach! 🙂

The VB scripts supported what I wanted to achieve.

Kind Regards,

Phil.

Thanks for posting, I will look into the formatting as suggested.

Many Thanks,

Phil.

Thanks, works a treat.

Kind Regards,

Phil.

Thanks guys, NULLIF worked a treat.

Phil.

As usual great work guys.

Many Thanks,

Phil.

Thanks for all your efforts.

My query comprises of 3 CTE's then a UNION ALL

I have posted my code. Apologies in advance as my programming skills are fairly basic...