To get the quarter you can use a calendar table that has the quarter specified for each day(if you have one).

Or something like this.

SELECT

CASE MONTH(GETDATE())

WHEN 1 THEN 'Qtr1'

--etc

WHEN 7 THEN...

• This reply was modified 9 months ago by  Chrissy321. Reason: typo

Provide error message as text masking any identifying information.

Yes I was talking about the Tabular Editor product. Better answer would be query MDSchema_Cubes

SELECT * FROM $system.MDSchema_Cubes

The docs look wrong since LAST_SCHEMA_UPDATE and LAST_DATA_UPDATE have the same description.

You can run Tabular Edit with the appropriate permissions to connect to your prod server. Then...

You can run Tabular Edit with the appropriate permissions to connect to your prod server. Then...

Does this help?

https://sqldusty.com/2011/08/01/ssrs-expression-iif-statement-divide-by-zero-error/

Why SSRS? Do you need user interaction?

If you don't need user interaction then there are better ways to do this. SSRS is for creating formatted output so I am not...

This sounds like more of an asp.net application issue rather than a SQL issue. I would not store links in the database. When you the user clicks the initial page...

This is tsql

DROP TABLE IF EXISTS #Roles;

SELECT * INTO #Roles FROM OPENROWSET

(

'MSOLAP',

'Data Source=localhost;Initial Catalog=YourSSASDatabaseName;Provider=MSOLAP.4;Integrated Security=SSPI;Format=Tabular;',

'SELECT * FROM $System.TMSCHEMA_ROLES'

);

DROP TABLE IF EXISTS #RoleMemberships;

SELECT * INTO #RoleMemberships FROM OPENROWSET

(

'MSOLAP',

'Data Source=localhost;Initial Catalog=YourSSASDatabaseName;Provider=MSOLAP.4;Integrated Security=SSPI;Format=Tabular;',

'SELECT...

You can issue an MDX query or a TSQL query against a linked server.

https://www.sqlshack.com/linking-relational-databases-with-olap-cube/

This?

SELECT * FROM $System.TMSCHEMA_ROLES

SELECT * FROM #TMSCHEMA_ROLE_MEMBERSHIPS

• This reply was modified 1 year ago by  Chrissy321. Reason: Added second select

Are there any performance considerations or other pros/cons in using EXEC at Linked server vs. OPENQUERY?

Example: EXEC MyLinkedServer.MyDatabase.dbo.sp_executesql @sql

Good point. I have a composite primary key comprised of 3 INT columns.

Maybe.

CASE WHEN SampleType = 1 THEN 0 ELSE PK1 + PK2 + PK3 END

Although I guess the 3...

Thanks for all the solutions. I'll adapt to my actual DDL and report back If I uncover anything notable.

This seems to work but I somehow doubt it will perform any better.

SELECT
DISTINCT
Color,SampleType,
SUM(SampleValue)OVER(PARTITION BY CASE WHEN SampleType = 1 THEN Color ELSE CONVERT(VARCHAR(MAX),RowNum) END) AS SampleValue
FROM
(
SELECT ...