This?

SELECT * FROM $System.TMSCHEMA_ROLES

SELECT * FROM #TMSCHEMA_ROLE_MEMBERSHIPS

• This reply was modified 8 months 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 ...

Like this?

SELECT Color,SampleType,

SUM(IIF(SampleType = 1, SampleValue,0))

FROM #SampleData

GROUP BY

Color,SampleType

It looks like RefreshedTime FROM $System.TMSCHEMA_PARTITIONS will not update when there is a processing error.

So by snapshotting RefreshedTime pre-processing and comparing to RefreshedTime post-processing you should see objects that did...

I believe that is the limitation of an Excel import. Try saving your file as a csv and then import as a flat file.

thanks, does anybody have access to enterprise?   The reason i ask is that there was a time when you had to use a backdoor thru multidimensional   to achieve this...

Thanks for the links Jeff. I am going to put PIVOT in the 'do not use' receptacle where it can hang out with MERGE. 🙂

Thank you both. Moving away from PIVOT and using the conditional aggregation method clearly gives me more flexibility to solve the problem and also seems to be performing better.

Can you contact the mail administrator? Intermittent mail failures can happen if there is smtp load balancing going on and you get sent to a mail server that is having...

Have you seen these links?

https://dba.stackexchange.com/questions/200367/can-ssrs-used-to-update-or-modify-data-tables

https://stackoverflow.com/questions/38583661/can-i-modify-data-by-using-ssrs

Sounds like you want a CRUD application.

CREATE means adding or inserting rows into a table.

READ means selecting (retrieving) rows from a table.

UPDATE means modifying...

How are you issuing the processing command? Are you using a SQL Server job with Type: SQL Services Analysis Services Command?

I dimly recall that error but I haven't seen it...

Yes, adding a date filter to my where clause seems to create a new plan causing the conversion error.

The Convert to VARCHAR seems reliable but imposes a performance penalty.

A better...