Generate restore scripts from backup history

Over the years I’ found this to be a very hand stored proc to generate the required SQL Server T-SQL RESTORE commands to recreate a recovered database out of the latest backup info: dumps to disk (full/differerential/log) and the history tables from MSDB