windows function

 use PWCIVICFCFL

go

with cte as(

SELECT CardNo,dbo.NtoW(Amount) as num,

        ROW_NUMBER() OVER (partition by CardNo ORDER BY CardNo) AS RowNumber

FROM PDXLogTable)

select CardNo,num from cte