The following SQL script reads accounts information out of an SQL database into an Excel spreadsheet:
SELECT TOP (100) PERCENT ClientId, PeriodEnd, Sales
WHERE (PeriodEnd > CONVERT(DATETIME, '2020-12-31 00:00:00', 102))
ORDER BY PeriodEnd DESC
There could be more than one line by client in the output, i.e. the client has multiple period ends. However, what we need is the first line it finds for a "ClientId" with the most current "PeriodEnd". The rest of the data can be discarded.
Therefore what syntax can I put into the script so that it only takes a single line for a clientid?
Thanks in advance for your help