I've used that TSQL type solution in the past. My problem with it is it uses a substring on the file name and those formats can and do change between versions etc.

The powershell I put together uses the file timestamp which is much more reliable.