I have a query report that doesnt deliver the expected result. Depending on "Order by" i get different results.

If i set order by 'Acquisition Date' asc i get 200 results in report

If i set order by 'Requester' asc i get 100 results in report

If i set order by 'Request ID' asc i get 300 results in report

This report should give me 379 results

Any Ideas out there?

select WO.WORKORDERID as 'Request ID', AU.FIRST_NAME as 'Requester', SCF.GUDF_CHAR3 as "Ansvar", SCF.GUDF_CHAR4 as "Verksamhet", SCF.GUDF_CHAR5 as "Aktivitet", SCF.GUDF_CHAR6 as "Projekt", SCF.GUDF_CHAR7 as "Objekt", SCF.GUDF_CHAR10 as 'Användare', SCF.GUDF_CHAR8 as 'Tjänste ID', SCF.GUDF_CHAR1 as 'Kopplad dator', SI.MODEL as 'Model', R.SERIALNO as "Serial", SCF.GUDF_CHAR11 as 'Enhet/Placering', convert(date, dateadd(s, (R.ACQUISITIONDATE/1000) + DATEDIFF(s, getutcdate(), getdate()), '19700101')) as 'Acquisition Date', convert(date, dateadd(s, (R.WARRANTYEXPIRY/1000) + DATEDIFF(s, getutcdate(), getdate()), '19700101')) as 'Warranty expiry' from WorkOrder as WO

left join ServiceCatalog_Fields as SCF on SCF.WORKORDERID = WO.WORKORDERID

left join RequestTemplate_List as RTL on RTL.TEMPLATEID = WO.TEMPLATEID

right join Resources as R on (((R.RESOURCENAME like left(SCF.GUDF_CHAR1, charindex('.', SCF.GUDF_CHAR1)) + '%') and charindex('.', SCF.GUDF_CHAR1) > 0) or (R.RESOURCENAME = SCF.GUDF_CHAR1))

left join SystemInfo as SI on SI.WORKSTATIONID = R.RESOURCEID

left join WorkOrderStates as WOS on WOS.WORKORDERID = WO.WORKORDERID

left join StatusDefinition as SD on SD.STATUSID = WOS.STATUSID

left join SDUser as SDU on SDU.USERID = WO.REQUESTERID

left join AaaUser as AU on AU.USER_ID = SDU.USERID

where RTL.IS_CATALOG_TEMPLATE = 1 and SD.STATUSNAME = 'Aktiv tjänst' and SCF.GUDF_CHAR8 = '40'

order by 'Acquisition Date' asc

Version : 9.1 Build 9121

Microsoft SQL