Database

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 !

SELECT O.Order_No, C.Address, F.Address
FROM Orders O, Address C, Address F 
WHERE O.Customer = C.ID 
AND O.Forwarder = F.ID(+)
AND F.OtherID = 1

SELECT  O.Order_No, C.Address, F.Address 
FROM    Orders O
JOIN    Address C
    ON  O.Customer = C.ID
LEFT OUTER JOIN Address F 
    ON  O.Forwarder = F.ID
    AND F.OtherID = 1

SELECT  O.Order_No, C.Address, F.Address 
FROM    Orders O
JOIN    Address C
    ON  O.Customer = C.ID
LEFT OUTER JOIN Address F 
    ON  O.Forwarder = F.ID
WHERE   F.OtherID = 1

SELECT  O.Order_No, C.Address, F.Address 
FROM    (
    Orders O JOIN  Address C
    ON  O.Customer = C.ID
    )   JOIN    Address F 
    ON  O.Forwarder = C.ID