• Thanks for the quick response, however, I am receiving the following error below:

    Msg 145, Level 15, State 1, Line 1

    ORDER BY items must appear in the select list if SELECT DISTINCT is specified.