What is the exact text of the error you are receiving? How do you even know that there is an error, if you cannot see it or trap it?

I should also mention that a lot of the 'good stuff' in PBI requires a 'Premium Per User (PPU)' or 'Capacity' subscription. These cost more than the entry-level 'Professional' subscription,...

Is there any equivalent in PBI for data driven subscriptions?

How is scheduling of reports handled in PBI? One use case I have for example is: 1) create an unscheduled subscription;...

I do have a follow-up question. When I've encountered PBI before, I got the impression that it required a server component somewhere in order to run. Even your response...

A pleasure. Let me know if...

The code probably worked perfectly on...

There are so many dead-to-me technologies, though as others have said, most live on in some form for some users.

SQL Server Reporting Services (SSRS) is dead to me....

Master Data Services. I've had a few goes at that in my time and it rarely ended well.

CD players and all hard-copy music. I stream all my music now.

There is no conflict.

SSL encryption is configured on the server/host.

When you connect to that server from SSMS, you decide what type of connection encryption to use (optional, mandatory or strict)...

DROP TABLE IF EXISTS #tblItems;

CREATE TABLE #tblItems (Rownr INT NULL, ItemID int NULL, Status nvarchar(50)  NULL , StatusDate smalldatetime NULL)

INSERT INTO #tblItems ( Rownr, ItemID , Status , StatusDate...

Can you provide your sample data in consumable format, please? Here is some skeleton code to help you get started.

DROP TABLE IF EXISTS #tblItems;

CREATE TABLE #tblItems (Rownr...

SELECT WOCode
FROM WorkOrders
WHERE Site = Section AND Section = CompletionDate

I'm fairly certain that this is not what you want, but that is what your post is asking...

I have a query Select Id, WOCode, Site, Section, CompletionDate from work orders where type = 'BRE'. I want to be able to return list of all WOCode that...

It would be helpful to know what the higher and lower versions of SQL Server are.

Note that you could use SSIS to move data from database A to database B...

Are there any temp tables...