with CTS AS(select id,Category from tblStringMap ) update tblStringMap set Page=(select Category from CTS where CTS.id=tblStringMap.Id)