if I understand right, you want to do an insert into 2 different temp tables from a CTE in a single query?  If so, I don't think that is possible. ...

My approach - get a monitoring tool to grab the data for you rather than watching things yourself and check the tool over a large timeline to get a baseline.

And...

I think the easiest way would be to join the tables in the query, but that may not be possible.  Failing that, I think your second dataset would need a...

Another approach would be to go back to your query where you have all of those CTE's and UNION all of the data from the non-master table in your second...

a_car11 - Just so I understand the question correctly, you want to get all of the records that ONLY exist in 1 of the 50 tables, correct?  I just want...

I think you will want to look into windowing functions.  in this particular example, remove your GROUP BY and change your SUM to:

,SUM(B.MappedAmont) OVER (PARTITION BY A.BudgetId,...

Offhand, I am not sure if activity monitor could do that, but I would not be surprised.  If I remember right, it opens a transaction when you open it and...

Not entirely sure why that would need to be "DNSLess"... you can use DNS without using ODBC.  But maybe I'm just misunderstanding the terminology.

Which brings me back to the first...

My first thought - what is the error?

Without the error message, it is hard for us to help.

Also, when you say "DNSLess", i am assuming you mean you are connecting...

Something like this i think should work:

USE [Admin];
GO
SELECT
*
 FROM[myTable];
DECLARE @CastedCols NVARCHAR(MAX);
SELECT
@CastedCols = COALESCE(  @CastedCols + N','
  , N''
  ) + N'CAST(' + QUOTENAME([c].[name]) +...

One solution may be to reduce the number of NCI's.

But, before looking at that, it may not hurt to grab an execution plan and see what is happening when you...

My opinion - the execution log on the task scheduler is not the approach I would take.  That will tell you the success/error code for the last command executed.  If,...

To me this sounds like either:

A - permissions

B - drive letter vs FQDN

I would check that SVCSQL$ has permissions to the files and folders and also  check if "D:\TEST" is...

I think the best way to find individuals from this forum would be to post what the project is and hope someone interested comes along.  That or reach out to...

I expect that you have either 2 Tablix's in the report OR you have the hidden property set on the column of the single Tablix that has your data that...