I don't think that we are in a position to take you much further with this task....

It would help if you would provide consumable data next time (check my code to see how this is done).

DROP TABLE IF EXISTS #SomeTab;

CREATE TABLE #SomeTab
(
 ...

• This reply was modified 4 years, 5 months ago by Phil Parkin. Reason: Slight code improvement

You seem to be having trouble understanding what is being requested.

What Jeff is talking about is that you provide us with some sample code which we can cut and paste...

A lot of people here use SQL Prompt and to get the most help from it during query writing, it's best to have the FROM clause written, including all JOINs...

Why not just give the column a default value in SQL Server? Perhaps you want all of the entries in the batch being process to have the same value.

It is not easy to query the content of packages which have been deployed to SSISDB, because the deployment process also encrypts the package contents.

But assuming you have all of...

I can't find the option either.

But try navigating to https://www.sqlservercentral.com/forums/user/<username>/messages/

That worked for me.

Might this work?

select s.Shipment_No, p.pkg_no, l.ord_no  -- You need to get ord_no from either s or p instead
from wsPKGShipment s
left join wsPKG p
ON s.Shipment_No = p.Shipment_No
where...

Nothing obvious comes to mind.

But as it's a dev environment, I'd be fairly brutal. Taking all of the User databases offline for a month and waiting for complaints is one...

What does your desired output look like? Is a list of all the source rows which are different good enough? Or do you want to see differences at the data-item...

• This reply was modified 4 years, 5 months ago by Phil Parkin.

1. Write a query to identify...

That is looking good to me – my sample data was incorrect. I was also thinking that a recursive solution was required, good stuff.

Good start, Ken.

In case others are interested in refining his, here is some sample data which trips up the solution:

INSERT #TestSUM
(
    ProductID
  ...

It was intended as a reminder to do some research yourself before posting here and getting other people to do it for you.

As a...

Had you done a quick Google search, as I did, you should have found this, which seems to do the trick:

https://stackoverflow.com/questions/2641068/sql-server-find-and-replace-in-text-field