Help with some sql statements

Good morning!

          I am a TSQL newb for the most part.  I know the data I am going after and can do everything I want to do manually.  But I am trying to script it and I am running into problems because I can't figure out the right ways to assign variables from queries.  We are basically doing quick validations of our backup process, taking a backup restoring it on another machine, comparing row counts from specific tables, and logging the results in another database.  I have a utility db that has a table that holds dbnames and specific tables and