>I currently have this statement
>

>select  TOP 1 *
>from CardDetail
>WHERE CardSN = 4162078351
>order by DateSaved DESC , TimeSaved DESC
>

>This statement is what I need but that is only for one CardSn, I need it for all CardSn in the table

I'm afraid this particular query can not be modified to run for all CardSN.