I think you've forgotten about the difference between Sample data and Production data, Joe. The OP is clearly using Temporary tables here, not persisted tables, and their attempts should be...

After the fact that storage is a problem too, I don't disagree. It should have been noted by the DBA that the backups were failing, but...

I have to agree, I think they're out...

Create 2 new variables in your packages (I have called them StartDate and EndDate) with the Data type DateTime, and then set their expressions to the below respectively (obviously replace...

• This reply was modified 6 years, 5 months ago by Thom A.
• This reply was modified 6 years, 5 months ago by Thom A.
• This reply was modified 6 years, 5 months ago by Thom A.

Will the file name always be the same length, or different lengths? If different, will the dates always be in the same position at the end? Also, there is no...

I assume, therefore, that the table doesn't have some kind of "last updated date" field? Considering that you have a inactive/active marker this suggests the inactive rows are history values,...

Microsoft are no longer supplying Service Pack updates for SQL Server 2017+. Instead, 2017+ will receive a CU every month for the first 12 months after the release, and then...

That's PowerBI, not SSRS. I've no experience with PowerBI afraid, nor what browsers it supports.

Tables can be declared in SQL Server, but you need to be specific. You can't just do something like this:

DECLARE @Table table;

INSERT INTO @Table
SELECT *
FROM dbo.MyTable MT
WHERE...

• This reply was modified 6 years, 5 months ago by Thom A.

rather than using a function, why not use dynamic sql (also not good) in your main code

declare @sql nvarchar(1000)
set @sql='select * from '+@table+' where '+@colum ='+@filtercode
sp_executesql...

• This reply was modified 6 years, 5 months ago by Thom A.

I don't believe it has ever been "officially" supported, as it's an undocumented procedure. That's...

I suspect the problem is the browser, not SSRS. What browser are you using?  It all browsers are supported by SSRS,  and which are depends on the version you're using...

I suspect that your SQL actually fails before it gets to the IN.  OR is a reserved keyword in T-SQL so you'd first get an error at your alias...

You're likely going to need a loop mechanic either way. You could, however, have a look at Aaron Bertrand's sp_foreachdb instead though.

The error is telling you the problem here. You have the subquery below:

SELECT SUM(CASE WHEN PPP.NRODIASFERIAS IS NOT NULL AND FER.PERIODOABERTO = 1 THEN PPP.NRODIASFERIAS ELSE 0...