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...

you need to change your code to send a string, not a list
something like (untested and not necessarily correct from a syntax point of view)

Cmd.CommandText = "SP_Insert_WC000311A_PremFormData"

can she really not do it or does she just get a warning stating she may not be able to do it? similar to https://sqlstudies.com/2014/07/10/db_ddladmin-and-the-ssms-table-designer/
or does she get a...

always output and visually compare on hex on these cases where it looks the same
(change 500 below as required to hold the content of the fields)

SELECT EmplID