Sorry, I figured it out. Those quotes aren't THAT confusing. Ha

askcoffman: What...

Thank you! My problem is solved. I installed .net library 3.5 on the server. Then I noticed the latest reply and fixed my select statement to include the quotes. Not...

Yessir, I have used sp_send_dbmail quite a lot on this server.  This is the first time for passing a parameter to @query, and the first time I've encountered this error...

These are perfect.  Thanks folks!

This is great!  Both work great.  Thank you both.

Thank  you.  As I was testing with it, when I run it for 11/15/19, I get the following, where the highlighted row is selected.  There is a gap before that...

Yes. Mine specifically is:

http://myServerName/Reports/Pages/Folder.aspx

...where myServerName is the name of my SQL/SSRS server

select *

from #Table1

where [201401]+[201402]+[201403]+[201404]+[201405]+[201406] <> 0

Thank you sir. I am going to try and automate that same process. And thank you for the tip on the SID mismatch. Luckily, all of the...

Thank you Sean! I like that one the best. I could wrap my mind around that one a little easier and it works great. I appreciate it.

Yea, what he said.

I'll give that last code a try. Thanks.

Thank you. I will definitely look into them some more. I should have mentioned my location. My company is in Texas. I'd prefer someone in the...

P.S. This person/company needs to be familiar with a virtual server environment.

We are running SQL Server 2008 R2

I deleted all of my schedules within each of my jobs and recreated them. That fixed it. It was a pain in the rump, but it did fix...