Can you supply the DDL for the original tables, not the ones you have altered to add the newid column

If your worry is just the index fragmentation you probably can avoid it if you change your application to generate a sequential guid instead of a "normal" guid.

The Oracle Attunity drivers are specific to Enterprise and are faster than the standard oledb/odbc drives supplied with the Oracle client.
Whether it justifies the extra cost is hard to...

OP seems to be gone.

I didn't post any idea or sugestion as I believe that what the OP is trying to achive is to execute the sql and...

I don't get the "4" . As far as I get it it should be 3
first date
first 3 are true - this is a consecutive 3
next one...

you need to escape the single quotes for that field - so 'test' becomes ''test''

A percentage is just a decimal type with X integers and Y decimals.
Most cases will store percentages as decimal (9, 4)  but this is always going to depend on...

I assumed you had the database already on 2017 instance.

you will need to create it first - I do not think you will be able to create it...

As far as I can see from the dump the issue was on wow64cpu.dll so going to be hard to identify the exact issue.

You may wish to play...

Most likely some values are null.

try and create a new table without any of the constraints e.g. set all to null and do not have any of the...

can be further simplified
; with mycte as
(SELECT a.MemberID
      , STUFF(
      (SELECT ',' + p.ProgramName
       From MemberProgram...

Can you provide sample tables and data on a consumable format as well as desired output.

although I think I know what you are after the above will not...

Good to know it was my expected "error".

It is a pain for those that don't know better - but in terms of security this is how it should...