Look at the database diagram?

Just saw a video from Chandoo (Excel MVP), right here.  Watch the next to last section - the biggest game changer in Excel in the last year is PowerQuery,...

Use sp_ForEachDB to loop over the DBs, and @@ROWCOUNT to collect the number of records affected/inserted?

I'd just create a counter variable and increment it after each insert. Then if you...

LEFT(SourceString,4) & FORMAT(RIGHT(SourceString,2),"000")

?

Thanks for the update. It's pretty much what I expected to have to do... use something (PowerBI, Excel) to generate the PowerQuery and then copy and paste.

What was the solution? I'd be interested to know, because I haven't used PowerQuery inside SSIS yet.

(Do you still have to write the PowerQuery in Excel or PowerBI and then...

Are you in SSRS or in ReportBuilder?

As far as I know, they should show if you're in SSRS. I haven't used ReportBuilder in so long I honestly don't remember anymore...

I want so say you create a function that generates the page(s) you need to go to. I saw Reza Rad do it in a class I took. It was...

It looks like you can now use PowerQuery as a source in SSIS.  The nice thing is that Excel can write PowerQuery for you - all you have to do...

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

Please help us to help you. Read Jeff Moden's article "Forum Etiquette: How to post data/code on a forum to get the best help", and follow the instructions outlined...

Each location with at least 3 different start dates.

SELECT loc
FROM (VALUES ('SAMSCLUB.COM','2021-12-05',42110)
,('SAMSCLUB.COM','2021-12-12',11731)
,('SAMSCLUB.COM','2021-12-19',9886)) d(loc,StartDate,Forecast)
GROUP BY loc
HAVING COUNT(DISTINCT(d.StartDate)) >= 3;

loc column will contain all values for which the predicate...

You'd evaluate "3 in a row" rule with something like

ThreeInARow = CASE WHEN columName = LAG([columnName],1) AND columName = LAG([columnName],2) THEN 1 ELSE 0 END

CREATE TABLE scripts are the scripts to create the tables that you have in your database. If you right-click on the table in the SQL Browser window, one of the...

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

You need to post CREATE TABLE and INSERT scripts so people who are trying to help you can work on your question and not guess about your table structures etc....

Look up STRING_AGG() function in Books Online.  It was added in SQL Server 2017.

So you're stuck with STUFF. Sorry.