Converting Access DISTINCTROW to TSQL

SQL Server Administration
5

Make sure to test it. One against access the other again sql