title: Is there any way to append the variable in big query select in stored procedure
body: <p>I am trying to call the variable in a select query like below:</p>
  <p>BEGIN</p>
  <p>DECLARE TGT_LOAD_STATUS_TBL STRING;</p>
  <p>SET TGT_LOAD_STATUS_TBL='<code>'||PROJ_ID||'.'||TGT_SCHEMA||'.'||LOAD_STATUS_TBL||'</code>';</p>
  <p>FOR FETCH_TEST IN (select col1 from <strong>TGT_LOAD_STATUS_TBL</strong> WHERE LOAD_STATUS='N')
  DO
  INSERT INTO project.datasetid.table VALUES(FETCH_TEST.col1);<br />
  END FOR;</p>
  <p>END</p>
  <p>Is there any way to append the variable in a select query?</p>