This should do it

ON t.RowNumber >= cd.RowNumber AND t.RowNumber < cd.NextRowNumber

Have a great weekend!

Actually getting some duplicate CreateDate rows in GroupingIdentifiers 2 and 3 using my sample data.

Thanks Scott. Definitely looks good initially.

The row count will be in the hundreds. Let me bounce this against my actual data and see if that brings up any complexities.

Thanks Jeff, Here is more realistic data. Won't work when there are more than 5 rows.

DROP TABLE IF EXISTS #Test
CREATE TABLE #Test (RowNumber INT,RowType VARCHAR(10),DelimitedColumn VARCHAR(MAX))

--Should all...

Thanks Scott. I suspected this would be CIY-code it yourself. The other approach I considered is not inserting the bad row at all. SSIS has error output which does this....

Sounds like you could declare a stored procedure output parameter and set it in your IF statement.

https://www.sqlservertutorial.net/sql-server-stored-procedures/stored-procedure-output-parameters/

Or if you need more flexibility you could use the OUTPUT clause.

https://www.sqlservercentral.com/articles/the-output-clause-for-insert-and-delete-statements

Welcome to the wonderful world of linked server performance troubleshooting,

Some will say never use linked servers and look for alternatives. https://www.brentozar.com/archive/2021/07/why-are-linked-server-queries-so-bad/

Others will say they are OK in certain circumstances. I...

Is there any equivalent in PBI for data...

Is there any equivalent in PBI for data...

I'll guess since you didn't post a way for anyone to post tested code.

Use LEAD to access subsequent data in the current row. Then compare AgentExpDate to the LEAD value...

This?

DECLARE @String VARCHAR(MAX) = '(abc.domain.com)'

SELECT @String,SUBSTRING(@String, CHARINDEX('(', @String) + 1, CHARINDEX(')', @String) - CHARINDEX('(', @String) - 1)

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 7 months, 1 week 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...