Noooo!!!! I thought this was it! Grrr @ you SQLC! 😉

Thanks guys. I didn't know of the SQL Agent. I'll try it out and let you know how I went. Cheers

Thanks again.

The last code needed a GROUP BY to work, but it works!

The first one didn't. It came back saying "Incorrect syntax near DISTINCT".

I assume that's the COUNT(DISTINCT...)?

Cheers

Hi Craig.

It's ok. I now understand the code, and how it relates to the query overall.

But I have a question... should be simple to answer.

I have the following code ...

SELECT...

Thanks Craig. I found that link too (yes I can use Google), but I didn't understand it. Your reply made more sense actually. Thanks

Thank you for your reply.

However, this does not answer my question exactly.

What I am after is a way to say to the database, ".. at 6pm tonight I want you...