C11/System/NAVISION/IQD/Serv_Teile/Monteure_fuer_Anzeige_offene_Auftraege.sql

select distinct "Order No" as "Order No",
	   "Type" as "Type",
	   "No" as "No",
	   "Last Name" as "Last Name",
	   "Entry No" as "Entry No",
	   "Qty Evaluated" as "Qty Evaluated",
	   RANK() OVER (partition by "Order No" order by "Qty Evaluated") as "RANG  (  Qty Evaluated  )"
from 
(select T1."Order No_" as "Order No",
	   T1."Type" as "Type",
	   T1."No_" as "No",
	   T2."Last Name" as "Last Name",
	   T1."Entry No_" as "Entry No",
	   (convert(float, T1."Qty_ Evaluated")) as "Qty Evaluated",
	   XRANK(((convert(float, T1."Qty_ Evaluated"))) for T1."Order No_") as c8
from ("NAVISION"."import"."Service_Ledger_Entry" T1 left outer join "NAVISION"."import"."Employee" T2 on (T2."No_" = T1."No_") and (T2."Client_DB" = T1."Client_DB"))
where (((((-1 * datediff(day, (getdate()), T1."Posting Date")) <= 120) and (T1."Order No_" LIKE 'WAU%')) and (T1."Type" = 2)) and (((convert(float, T1."Qty_ Evaluated"))) <> 0))
) D1
where (c8 = 1)
-- order by "Order No" asc