pramodbr2002 26-Jan-2011 @ 7:09:25 AM
@sriram-2, I am actually populating a table variable through this query, hence wanted to get the join working.
my xml dataset is quite small, so having a join directly should be ok i guess.
If your XML dataset does get larger, you might want to consider inserting it into a temp table and using that to join to the main table.
Todd Fifield