So you did not even try my solution, which takes care of that issue.

Hi Jeff,

Sorry for coming back to you late. The code below is removing the first 3 character.

Do you know what would be the workaround to only substract the last...

Probably because most people don't run multi-instance servers.  Other than that - I have no idea why some would have an issue and others would not.  All I can do...

Review this issue: https://feedback.azure.com/forums/908035-sql-server/suggestions/32897173-syspolicy-purge-history-agent-job-tries-to-access

It is a known issue and not much you can do about it, unless you want to grant permissions to each service account on each instance on...

That's where you and I would differ... to me, the "customer number" would be the IDENTITY column.  Or, perhaps, a Random GUID. 😀  Why would your "customer number" not...

Here is an alternate version

   With accountData
     As (
 Select Distinct
        td.[Year]
  ...

Is your data really broken out by year and month?  With the month value set as char(2)?

Will you only ever be querying for a single year - or will it...

Instead of trying to use a case expression - it would be much simpler to calculate the values to be used.  For example:

Declare @option numeric(3,1) = 3.2...

What is the data type of the parameter @EmailAddress?  How are you passing the encrypted email address from the application to SQL Server?  If you have different data types at...

Hah, stupid phone ??

Now - I would add the column alignment and format the generated SQL so it is easier to read.  If you don't care if the data is aligned in the...

According to the article in the link - there isn't something specific to reporting services.  The counters are .NET related counters:

Performance object

Notes

.NET CLR Data and .NET CLR Memory

The web portal uses ASP.NET...

THis is where I believe I need to make a change to get into the Description and the Column totals..

concat(', coalesce(sum(Case When ft.Entity = ', h.Entity, ' Then ft.total...

If you are running SSRS 2017 or later - the performance counters are no longer available.  See this document: https://docs.microsoft.com/en-us/sql/reporting-services/report-server/monitoring-report-server-performance?view=sql-server-ver15

 Note

Power BI Report Server and SQL Server Reporting Services 2017 and...

For something like this - you can probably get away with using FORMAT although it is incredibly slow.  You can also use concat and convert to get the same result:...

• This reply was modified 4 years, 11 months ago by Jeffrey Williams. Reason: Used a picture for the align - site took that as a directive