It’s funny nobody suggested the most obvious choice in such situation - RIGHT JOIN:

Select s.Shipment_No
     , p.pkg_no
     ,...

For 2016 and below - you can use FOR XML, for 2017 and above you can use STRING_AGG.

Declare @testData Table (Widget_ID int, Widget_Name varchar(10));
 Insert Into @testData...

You could also use OUTER APPLY or a CTE.  The derived table (sub-query) is essentially the same thing as using a CTE - I personally like the CTE construct better,...

Okay - you say the data was properly formatted, but it generated an error.  Since you never provided the error - the only conclusion is that there was a problem...

For me, I'm woefully inconsistent. I'd have:

create table dbo.Sale
( SaleID int not null constraint SalePK primary Key
, SaleDate date
)
go
create table auditing.Sale
( SaleID int not null constraint...

Yeah - that sounds similar to an issue I had a while ago and it was related to SQLPS.  It might actually be better - since you can pass on...

If this is representative of the data in the files - then no wonder you had issues.  That is not...

Just curious, but what do you do when you have the same table in multiple schemas?  For example - you could have the same table in a staging schema and...

It would help if you provided the errors you are getting - no idea what the problem is if we cannot see that information.

You may want to change your NOT IN to exclude the correlation.  It isn't needed and may be skewing the results...the real answer to your question is: it depends.

EXISTS vs...

In your procedure you would have 3 statements.  The INSERT to add new rows to the final table, an UPDATE to update those rows in the final table where the...

Why would you be concerned about the version of SQL Server?  That should not be dependent in any way on the version of .NET you are using in the application,...

I think I had a similar issue years ago - it has been a while so I may be completely off-base.  Some constructs are not valid in SQLPS because the...

So which row in the trace are you looking...

First - thanks for the response.

In the example you give the date is the same for both start and finish so it will never return any records. I can...