hmm.. for some reason it says that the last post by me but I can't see it

UPDATE: weird.. I could see only 3 pages and once I posted this...

Thanks for verifying.

In addition, it seems that I...

Borrowing Jeff's code a little, here is another version:

DECLARE @Year NVARCHAR(50) = N'201901';
SELECT STUFF(@Year, 5, 0, '0');

Not only is the NVARCHAR() datatype a terrible choice, but calling...

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 ago by Phil Parkin.
• This reply was modified 4 years 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 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...