thanks for the head start... I was curious, so I finished it.

 SELECT nm.item,
 Name = NU.Item 
  FROM test T
  CROSS APPLY SCRIDB.dbo.DelimitedSplit8K(T.name, ';') NM
  CROSS APPLY SCRIDB.dbo.DelimitedSplit8K(T.numbers,...

You need to help you. Read the articles Chris posted. Create some tables, try out the different options - LEFT JOIN, EXCEPT, NOT IN.

I'd probably send a tweet to @psdbatools and see what happens. or #psdbatools

Maybe this will help?

https://social.technet.microsoft.com/wiki/contents/articles/1073.robocopy-and-a-few-examples.aspx

There's not enough data to test your query, but this is the general pattern and should work:

use tempdb;
GO
CREATE TABLE #ToGive (
 GiverID INT,
 NumGifts TINYINT,
 GiverName VARCHAR(10),
 City VARCHAR(15)
 );
GO
INSERT INTO #ToGive...

• This reply was modified 6 years, 4 months ago by pietlinden.

So what do you really want to do?

Modify the subscription so it changes when the report is delivered? If so, see the "Schedule" section of this article:

https://docs.microsoft.com/en-us/sql/reporting-services/lesson-3-defining-a-data-driven-subscription?view=sql-server-2017

Sorry for the silly question, but if you do everything in a stored procedure, what's the difference? Maybe you have a CTE with two pivots in it, and then at...

Not totally sure I understand. Can you create two pivots and then join the results on the shared columns?

Something like this... I'm not sure my query is 100 percent correct, because I'm not sure what D_ID and E_ID mean.

SELECT D_ID
 , E_ID
 , Salary
 , LAG(Salary, 1) OVER...

Can you get the data before it's pivoted, so there are dates in there instead of quarters? Normally in a tabular model, your fact table will have a date or...

• This reply was modified 6 years, 4 months ago by pietlinden.

There's a new cardinality estimator in SQL 2016.  Force your query to use the old one. See: https://stackoverflow.com/questions/47215135/facing-performance-issues-in-sql-server-2016-after-migration

Sounds like a job for CROSS APPLY.

SELECT e.EquipmentName
 , lw.WarrDescription
 , lw.StartDate
 , lw.EndDate
FROM Equipment e
CROSS APPLY (SELECT TOP 1 StartDate, EndDate, WarrDescription
             FROM Warranty...

Multiple UNIONs? That's a recipe for a long long wait. Can you post the query?

You can try using UNION ALL between the individual queries instead of UNION. UNION will remove...

• This reply was modified 6 years, 5 months ago by pietlinden. Reason: forgot about the OR

got CREATE TABLE and INSERT scripts?

That post is nonsensical without them

I did the Prerequisite/Co-requisite course thing a long time ago, and asked about it there. So if you look for it, Jeff Moden and someone else answered and came up...