Convert MSAccess Query to MSSql Query

SELECT t.[device name], t.[Disk Storage Used(GB)], t.[scan date] AS scandate
FROM [Disk Trending Report] AS t, (SELECT d.[device name], max([Scan Date]) AS scandate FROM [Disk Trending Report] AS d GROUP BY [device name], Format([Scan Date],mm/yyyy) ORDER BY [Device Name])  AS r
WHERE (((r.scandate)=[t].[scan date]) AND ((r.[device name])=[t].[device name]))
ORDER BY t.[device name], t.[scan date];