Yes logically its unsorted, but as per users entry it is sorted, as i already have a store procedure that meets the requirement but the report is non ax, as i want to make a report in ax ... I am copy sharing with you the the SP.
ALTER PROC [dbo].[LoyaltyCardPrint] @Cardno VARCHAR(MAX)
AS DECLARE @vCardno VARCHAR(MAX) = ISNULL(@Cardno,'')
SELECT PAR.NAME,LOC.ADDRESS
,cci.CARDNUMBER,
ISNULL(PH.LOCATOR,'') [Phone]
,ISNULL(EM.LOCATOR,'') Email,SPL.idx
, ct.ACCOUNTNUM SL_LOYALTYACCOUNTNUM
FROM CFZ_CUSTOMERCARDINFORMATION CCI
inner join CUSTTABLE CT
on CCI.ACCOUNTNUM = CT.ACCOUNTNUM
and CCI.DATAAREAID = ct.DATAAREAID
LEFT JOIN DIRPARTYTABLE PAR ON ct.PARTY = PAR.RECID
LEFT JOIN DIRPARTYPOSTALADDRESSVIEW LOC ON PAR.PRIMARYADDRESSLOCATION = LOC.LOCATION and LOC.VALIDTO >= '2154-12-31 23:59:59.000'
LEFT JOIN LOGISTICSELECTRONICADDRESS PH ON PAR.PRIMARYCONTACTPHONE = PH.RECID
LEFT JOIN LOGISTICSELECTRONICADDRESS EM ON PAR.PRIMARYCONTACTEMAIL = EM.RECID
LEFT JOIN dbo.fn_split(dbo.CleanAndTrim(@vCardno),',') SPL ON SPL.value = CCI.CARDNUMBER
WHERE cci.CARDNUMBER IN(SELECT VALUE FROM dbo.fn_split(dbo.CleanAndTrim(@vCardno),','))
ORDER BY SPL.idx
Therefore, As you can see here i am ordering it by user's input via storeprocedure.
SELECT VALUE FROM dbo.fn_split(dbo.CleanAndTrim(@vCardno),','))
ORDER BY SPL.idx
