A resource link for the correct answers was not included in the answer section. Here is one that will help you find out which one(s) were right...

Thanks Gentlemen!

To answer your questions, the base table contains millions of records but the query results contains only 3 records, so I inserted those three records into a temp table. ...

Suresh,

You need to declare the variables after the 'go' statement.  The 'go' statement signals the end of a sql batch and closes the scope for those variables.  If you move...