+1, we definitely need this in order to be able to give you a coded solution.

Assuming the package has been deployed to SSISDB, it may be called (with parameters as needed) from a stored procedure. Would that help?

Given that the results of a single query must always have the same number (and datatype) of columns, there's no straightforward way of doing this. With some juggling, you may...

When we create a foreign key using UPDATE CASCADE the referencing rows are updated in the child table when the referenced row is updated in the parent table which...

I am having some kind of proprietary database with the file extension of .DSE i would like to import those in SQL Server  2019

Is there any way to import...

If you are hoping for a coded solution, please provide DDL and INSERTs with sample data, and desired results based on the sample data.

Where do you want to run the code from? SSMS? SQLCMD? C# app? Something else?

I assume you will design a registration table (MemberId, LocationId, DateRegistered, etc), with FKs to Member and Location? If so, add a Boolean 'IsPrimary' to that table to denote the...

You're apportioning blame in...

That is a common problem when importing from Excel. The way I handle it is

1. Add IMEX=1 to the Excel connection string
2. Include the header row in the import, as...

• This reply was modified 3 years ago by Phil Parkin.
• This reply was modified 3 years ago by Phil Parkin.

That looks like a good dataset, and I'm sure that your explanation makes plenty of sense, to people who understand the data!

But I'm not one of those people, so would...

Please provide a CREATE TABLE script for [Cranes].[dbo].[LPKCColmnized], along with your desired results, based on the provided sample data (which would be easier to use if it were provided as...

Sounds rather complex. You might be better off putting this into a view or stored procedure.

Are you using global temp tables rather than local ones for a reason? Local temp...

I suspect you'll find that this is a fairly thankless task, once you expand your dataset to include other name varieties, but this code works for your sample data. It...

Can you explain the rules? Looks something like

field1x-field2x-field3x----

where fieldnx = replace(fieldn,'-','')

except your sample data desired output is all over the place

a) the ordering of fields is inconsistent

b) the number of...