That is good to hear - thank you for the feedback.

Did you restart the reporting service after granting the elevated rights?  Verify permissions on the accounts NT SERVICE\SQLSERVERAGENT and NT SERVICE\MSSQLSERVER.

You are welcome - thank you for the feedback.

 --==== Sample data
Declare @testTable Table (Category char(1), [Month] int, Amount int);
 Insert Into @testTable (Category, [Month], Amount)
 Values ('A', 1, 5)
     ...

You can get around that issue by creating a new database at 130 compatibility - and place your code in that database.  You will need to use 3-part naming or...

To be able to view the definitions of objects - and therefore see them in Object Explorer - you need to GRANT VIEW DEFINITION to the user in the database.

For the date column comparison - you should use the following:

AND FSS.SNAPSHOT_DT >= DATEADD(dd, -1, CONVERT(DATE, SYSDATETIME())
AND FSS.SNAPSHOT_DT <  CONVERT(DATE, SYSDATETIME())

Assuming FSS.SNAPSHOT_DT has the data type...

This is actually quite simple - the problem is in your where clause.  When you outer join a table - you get all results from the preserved table (the left...

Okay, I don't have control over the DNS process. I filled out a form and sent it along. I'm told it's set up the same as working instances. Also,...

I think part of the problem is that a CNAME only defines the IP address - and not a port.  Using just 'MickeyTest2' gets you to the IP address -...

You might be able to setup a Powershell script to do this - and setup the agent job to execute that script.  A simple driver table to identify the parameters...

Is the SQL Browser service running?

Answered on SQL Team: https://forums.sqlteam.com/t/summary-query-for-number-of-attendees-out-of-all/18890/6

For a bunch of string fields, numbers you're absolutely right.

I use the last excel file, which I just go into and change the query save it and send it....

I know I'm not answering your question here.

I'd be mindfull about copying and pasting data from SQL to Excel because of locales; how does Excel know what format your...