Hello all! I hope everyone's great

I have these columns here that are hour and minute for entry and for exit. I also have a column that let us know...

As you are using row-by-row processing, why not use a CURSOR?

It is possible, and if you search for 'consume data in ssis from rest api' or similar, you will find numerous examples of this.

However, it might not be as straightforward...

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