A very similar question of yours has already been answered here.

Thanks Des, that is much tidier.

This gets you most of the way there. I have not yet worked out how to handle the space in 'Case ID' though.

DROP TABLE IF EXISTS #SomeXML;

CREATE...

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

Does table 2 contain any data currently?

If you need to control the value of EmpNo in table2, you should set it to be an INT, but not an IDENTITY.

Can you...

Try this

SELECT customer_name
      ,order_id
      ,status = (CASE
          ...

CONCAT is not a safe way to do this because different values could appear to be the same.

Do all the columns have to match?  Or just some?

For now, I'll...

Jeff's queueing idea is the way I would do it.

Doesn't feel like a 'nice' solution, but this might do it.

DROP TABLE IF EXISTS #t;

CREATE TABLE #t
(
    Id VARCHAR(100)
   ,C1 INT
 ...

As far as I know, there is no migration tool.

(But in all the time I've been involved with SQL Server, I've never worked anywhere that even uses SSMS projects, so...

Use STRING_AGG(). This might work (difficult to test without DDL and sample data):

SELECT distinctid = STRING_AGG(AtcCode, ',')
      ,Atc_Text
FROM dbo.Drugs_BasicData d
  ...

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

What's your point and how does...

(Please note that I have not yet performed a migration of SSISDB to 2019, so my comments are educated guesswork.)

I think you may have already identified the reason for the...

The syntax you used in your post is the syntax I would use for selecting only those rows where all three conditions are satisfied.

SELECT ...
FROM ...
WHERE condition1...

I really doubt it. Show us your WHERE clause, please, plus a sample of the data which is selected which you say should not have been.

OK, that makes it more tricky. It should be possible to extract those connection strings into a package-scoped variable, but I think you would need to add a Script Task...