Now all is perfect .. Thank you guys for your help, the final code is :

SELECT JT.TRANSID
      ,JT.ITEMID
    ...

No, I do not want to create a view, this select will be feed by the Robot running the RPA process that this SQL should be used in, I just...

@anthony.green :

Actually the below code is doing exactly what it needs to do, exect I have difficult getting it to ORDER by TRANSID, it says The ORDER BY...

@anthony.green :  The query take more than 10 minutes to run using WHERE Clause at outer select, and approcimately 3 minutes to complete placing inside the inner join.

Here...

• This reply was modified 4 years, 9 months ago by  sk 939.

Hi Ten,

Thank you for your code 🙂 .. it looks it will do the trick, but the Query have now run for +5 min and I have not gotten the...

• This reply was modified 4 years, 9 months ago by  sk 939.

Hi ChrisM,

Thank you very much for your explanation, and the cleaning of the code - that is REALLY a lot more simple than my piece, GREAT!! .. Your...

I found a solution using another forum, and the solution if anyone is interested was this :

SELECT Afdeling,[Process Navn],body,Interval,SubjectContains
FROM
(
SELECT DISTINCT dbo.folders.name AS "Afdeling",...