Be careful with that approach.  Please see here.

John

SELECT type_desc, name, physical_name
FROM DBName.sys.database_files

Make sure you use the REPLACE option in your RESTORE DATABASE command if you're overwriting an existing database.

John

Do you know the name of the database that each file is a backup of?  If not, use RESTORE HEADERONLY to get the database name.  You'll also need to use...

You've got some sort of rounding error there.  Does this help to explain it?

John

Perhaps something vaguely resembling this.  I can't test it because there's no sample data and the columns in your query don't match those in your table DDL.

[code...

Troubleshooting deadlocks is a time-consuming process, so you may find that others are reluctant to do this before you if you haven't done a bit of work on it yourself. ...

In those last three conversions you're doing, you're mixing the syntax for CAST (which uses "AS datatype") with the syntax for CONVERT (which uses a comma-separated list of parameters).  Why...