bolt declared variables onto a table returned in SQL

The last line of the stored procedure should change from this:

select * from #Baz

 
 

To this:

select @Foo as Foo, @Bar as Bar, * from #Baz

 
 

#Baz will come back to you with two extra columns. An extra column will hold the same value over and over again in each row.