This has got to be close.  It looks right, although my result set has 180 rows whereas yours has 184.

WITH USandLocal AS (
    SELECT
   ...

Closer, but you've missed out the VALUES keyword and haven't put string values in quotes.  It's a good idea to test code before posting it on a forum, if you...

I thought your query worked, except for the last column, which I fixed for you?

This query should work for your sample data and expected results.  Note that...

Sounds very much like a homework question.  What have you tried?

One approach would be to use a splitter function to split that part the string into its individual...

You can use a variable in the BACKUP statement for the database:
DECLARE @DB sysname;
SET @DB = 'master';
BACKUP DATABASE @DB to DISK = 'NUL';

I...

Just search the documentation for TRUNCATE.

John

Jason

13/04 is different from 12/04 and so on in that it can only be interpreted as dd/mm.  The others were interpreted in your code as mm/dd, perhaps due...

You appear to be using SQL Server 2012.  The WITH PARTITIONS syntax is only available in SQL Server 2016 and higher.

John

We're getting to the stage where we need some table DDL (CREATE TABLE statement(s)) and sample data (INSERT statements) if we're going to be able to provide any more help. ...

"Component" is just an alias.  It's not a column of table b (VndrCmpntNum ).  Remove the "b." from the ORDER BY clause and it should work.

John

I think even the security update includes the CUs, but I wouldn't swear to that.  Might be safer to install the latest CU and then the security update.

John

Thanks Grant.  Yes, absolutely.  The only reason I specifically mentioned security updates was in response to the second question in the original post.

John