Viewing 2 posts - 1 through 2 (of 2 total)
Try searching for 'universal table' in MSDN. In there it explains how to set up the xml.
You might want to try
Create Table #xml(Tag int, Parent int,[Contact_Information!1!Root] char(19), [Detail!2!Name] char(20),[Address!3!FirstLine] vachar(30),...
March 1, 2005 at 1:46 pm
#544694
http://support.microsoft.com/default.aspx?scid=kb;en-us;285006
http://support.microsoft.com/default.aspx?scid=kb;en-us;279430
These might be of interest
October 5, 2004 at 2:30 am
#525336