I’m currently writing an SQL Script for Work. I want to store multiple Values in a temp_table with specific Columns. Later in the script I want to refer to the columns with a case. I Also want to refer to those columens with a specific row and i don’t know how.

I’m currently writing an SQL Script for Work. I want to store multiple Values in a temp_table with specific Columns. Later in the script I want to refer to the columns with a case. I Also want to refer to those columens with a specific row and i don’t know how.

If I have the following tables (just an example):

I want to fetch first x rows only by the column IDENTIFIER.
But when I join abbrev table, its get multiplicated the result, because each identifier could have more than one result.

ID ABBREV 1 A 1 B 2 B 2 B When I am filter for ID = 1, then I want in my result only the first line a result, A has priority on same id. When I am filter for ID = 2, then I want both results, line 3 and 4, because A […]