Want to know the latest news and articles posted on SQLTeam.com Forums - Latest posts?
Then subscribe to their feed now! You can receive their updates by email, via mobile or on your personal news page on this website.
See what they recently published below.
Website title: SQLTeam.com Forums
Is this your feed? Claim it!
This error usually shows up when you're running the query in a distributed SQL environment where certain objects or system views aren’t supported. Try running just a simple SELECT Col1 FROM YourView without the recursive CTE. If this fails, the view itself isn’t supported in that environment. Else, if it works, then the recursive logic or underlying object may be the issue. I...
The strange thing in this case is that the initial report is (only sometimes) sent without data, but if we manually rerun the subscription, the report (an attached Excel file) has data. Very strange.
This usually happens when the subscription runs under different user contexts or parameter values.
Check if the user getting the empty report has filters or row-level security applied that return no data. Also verify the subscription owner’s credentials — SSRS runs the job using that account, which can affect data access.
If parameters and permissions look fine,...
You cannot do this. If you want more information you should look for CTE. It would be something like this:
;WITH F AS
(SELECT ColumnA,
ColumnB 1 AS lvl
FROM dbo.datasource
WHERE ColumnB IS NULL
), F2 AS
(
SELECT FL.ColumnA, FL.ColumnB,lvl + 1 AS lvl
FROM F
INNER JOIN dbo.datasource FL ON F.ColumnA = FL.ColumnB
)
SELECT *
FROM...
Your DSN is likely using the ODBC Driver with MFA, which is notoriously difficult to call directly from VBA/ADO, as it often fails to prompt the user for credentials.
The recommended approach for VBA with MFA is to use the MSOLEDB provider along with the Authentication=ActiveDirectoryInteractive connection string property.
