You want to see all of the codes from all of the different tables in a single column?

For that, you will need a UNION query and no joins at all.

Here is some dynamic SQL to give you an idea. You cannot 'inject' variables into column aliases using 'normal' T-SQL.

DECLARE @Yr SMALLINT = 2022;
DECLARE @Sql VARCHAR(MAX)
 ...

Maybe something like this?

WITH result
AS (SELECT TOP(1)
           t.Id
    FROM dbo.Transfer t
   ...

Hi Jeffrey,

yes, SSRS is a brilliant idea. not sure why it didn't occur to me. I had created few SSRS reports in past.

I will consider SSRS or a python...

+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 2 years, 10 months ago by Phil Parkin.
• This reply was modified 2 years, 10 months 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...