One of the reasons I used CTEs is my understanding that they are cached so they are not re-calculated each time they used.  Is there a way to tell...

the issue is not the sql itself but the whole combination - your system is likely constrained in memory and was unable to produce a plan for the full...

• This reply was modified 3 years, 10 months ago by Jeffrey Williams.

In your total columns - you are referencing the dataset column, which totals across the full dataset.  Try referencing the text box name instead of the dataset column.

Can you run SELECT @@version in a query window connected to that instance?  Either you are running SQL Server Express or you do not have permissions to the agent.

You can remove tbl1 from the query and use some other check to exclude the rows - for example, use IN or EXISTS.  You could add one or more columns...

The error is clear - you need at least 1 column that is not from the outer reference - that is, at least one column from [tbl1] in the group...

Looking at your pictures - you are not using the Integration Services Catalog.  I would recommend that you setup and configure the catalog and modify your packages to project deployment...

That is a standard type of schedule in SQL Server agent - what issue are you having setting it up?

@jagjitsingh,

I think you have been around enough to know how to post code using the insert/edit code sample button.  It would make it much easier for people to review the...

I would recommend the proxy account as the best solution.  If you modify SQL Server Agent to run as a domain account (actually, that should be setup and configured with...

Wouldn't that be related to parameter sniffing in the scenario I gave vs function in a WHERE clause in the OP?  And if so, the performance could tank...

Can you identify each service account - and where that service account is being used?  If the service account is a proxy account - it will be defined in the...

It's always been interesting to me how much time and effort is spent on how to identify the "same time period" for the previous year as the current year. ...

You can also use this site: https://www.brentozar.com/pastetheplan/

If you use the above, posting the code here would also be a good idea - even if the code is included in the...

Unless there is a requirement to scale-out your SSRS deployment - then I would not recommend hosting the databases on a separate instance of SQL Server.  Just install both the...