UPDATE #variables.tableprefix#issues SET googlecalid = WHERE issueid = select googlecalid from #variables.tableprefix#issues where issueid= UPDATE #variables.tableprefix#milestones SET googlecalid = WHERE milestoneID = select googlecalid from #variables.tableprefix#milestones where milestoneid= UPDATE #variables.tableprefix#todos SET googlecalid = WHERE todoID = select googlecalid from #variables.tableprefix#todos where todoid =