Sorry guys,

I haven't used Outer Apply much. I get the column name in the output and have to force a replace on the close and open tags in the select list to get rid of them. I have googled for an hour and can't find why this happens. I just want the data in the column. Thanks.