Ok so I got the basic dynami query to work but am not trying with:

exec ('update temp_data set nu_m13_prior_amount =

  (select '+ @dc_prd_year1 + '

  from taco_sales where store = '...

That makes sense except that I thought I tried that (I feel like I have tried a million things to get this to work) and when I added the quotes:

Thank you that worked great!

Thank you. I will read that article. As I use it I already see why it is not much fun. Now I am trying to take that select and use...