Hi, To give you a better understanding, I am just trying to create a replica of my situation, so kindly ignore any syntax errors: In the following temporary table, i have inserted 1000 employee ids, based on some previous different selections: XML columns are null at the moment create table #tmpEmpXML...