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 3 years, 11 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 3 years, 12 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.

You would have to use two separate queries to accomplish it if you replace the LEFT JOIN.

UPDATE r
SET r.HasChemical=CASE WHEN cm.partid IS NOT NULL THEN 'HasChemical' ELSE...

• This reply was modified 4 years ago by pietlinden.

You would have to filter those out in the WHERE clause in the inner query.

SELECT FIRSTVALUE(…)

FROM (Select…WHERE elementID !=‘C’)

Disassemble the CTE into single queries and run them one at a time?

insert the intermediate results into a temporary table once you fix them and then query tempdb?