C11/System/ARI/IQD/Service/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",
	   XRANK("Qty Evaluated" for "Order No") 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 ("Vogl7x"."dbo"."BMW AH Vogl$Service Ledger Entry" T1 left outer join "Vogl7x"."dbo"."BMW AH Vogl$Employee" T2 on T2."No_" = T1."No_")
where (((((day((now()) - T1."Posting Date")) <= 120) and (T1."Order No_" LIKE 'W%')) and (T1."Type" = 2)) and (((convert(float, T1."Qty_ Evaluated"))) <> 0))
) D1
where (c8 = 1)
-- order by "Order No" asc