I can generate my own uniqueID and I did that too but there...

Phil,

I can't create table (nor store procedures for example or views) because I don't have any other database access except for reading. Normally I import data and start working...

Yes. Provide your sample data in the form of CREATE TABLE / INSERT statements.

If you do that, others can copy the text straight...

What do you mean by 'fix' exactly? Do you want to generate a unique Id yourself?

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

You are dead right.

I'm so sorry guys, wrong CASE

(CASE WHEN CAST(DH.OPENING_HOUR_H AS INT) BETWEEN 10 AND 16 THEN 'Lunch' WHEN CAST(DH.OPENING_HOUR_H AS INT) BETWEEN 16 AND 19 THEN 'Snack' ELSE 'Dinner' END)...

I'd probably use a mapping table rather than a rambling CASE statement - makes the code easier to read, particularly if there are lots of distinct grades to be updated....

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

Not directly related to your issue, but there are a couple of good-practice items I suggest you consider:

1. Always qualify your tablenames with their schema
2. Try not to include DDL...

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