Database

create table products(product_id int, next_id int, product_name nvarchar(50));
insert into products(product_id, next_id, product_name)
Values (1, null, N'product1')
,(2, 4, N'product2')
,(3, 2, N'product3')
,(4, 1, N'product4')
,(5, 3, N'product5');

WITH LinkedList (product_id, next_id, product_name, Level)
AS
(
-- Anchor member definition
    SELECT e.product_id, e.next_id, e.product_name, 
        0 AS Level
    FROM products AS e
    WHERE e.next_id IS NULL
    UNION ALL
-- Recursive member definition
    SELECT e.product_id, e.next_id, e.product_name,
        Level + 1
    FROM products AS e
    INNER JOIN LinkedList AS d
        ON e.next_id = d.product_id
)
-- Statement that executes the CTE
SELECT product_id, next_id, product_name
FROM LinkedList
Order by Level desc;

drop Table products;

BEGIN TRANSACTION

	CREATE TABLE SomeTest(
		Field1 INTEGER,
		Field2 CHAR(1),
		Data VARCHAR(50))
		
	INSERT INTO SomeTest VALUES (1, 'C', 'Test')
	INSERT INTO SomeTest VALUES (1, 'A', 'Test')
	INSERT INTO SomeTest VALUES (7, 'C', 'Test')
	INSERT INTO SomeTest VALUES (7, 'A', 'Test')
	INSERT INTO SomeTest VALUES (4, 'C', 'Test')

    SELECT *
         , ROW_NUMBER() OVER ( PARTITION BY Field2 ORDER BY Field1 ) 
      FROM SomeTest
    
ROLLBACK 

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

some idiot forgot to added an identity-field

Ambertje wrote:

I want to make a dayset so that we only read one single day into the DB on top of the existing data and not the whole year.

Ambertje wrote:

and takes a long time to process.

Klaus-Werner Konrad wrote:

Arguments,

Mycroft Holmes wrote:

Nope, I call them Oracle joins

Mycroft Holmes wrote:

I will [...] have a short, sharp discussion with the dev that uses it

Klaus-Werner Konrad wrote:

THIS is my Intention - to have a DISCUSSION about it !