Things are fine except while trying to read one column both by select statement and while using a CTE, i get column not found error.Can anyone advise why I am getting this error even though the column is present both in xml data and table definition.I have attached the script for having an idea of the problem I am facing.thanks :)