Get the columns from the XML data

I have table with following columns

tblProductProperties

(ID {Bigint},

Name {Varchar},

AccountID {long},

FileDate {DateTime},

RawXMLData {xml}

)

Now raw xml is contains data as follows

Some Int values

Name1

Name2

Some Int value

Text value

Weight description

select * tblProductProperties

out put of query looks like as follow

ID Name AccountID FileDate RawXMLData

101 ABC 123133 2014/11/12 " 1293 Joan Wade [email protected] 93 Red 60GMS "

102 AVC 120201 2014/11/12 " 1292 Name1 Name2 [email protected] 92 Blue 60GMS "

Now i want to show output as follows

ID Name AccountID FileDate RAW_CODE CORRESPONDENCE_ID FIRST_NAME LAST_NAME COUNTY EMAIL ACCTID COLOR WEIGHT

101 ABC 123133 2014/11/12 NULL 1293 Joan Wade Null joan2054@ 93 RED 60gms

yahoo.com

102 AVC 120201 2014/11/12 NULL 1292 Name1 Name2 NULL name1@ 92 Blue 60gms

yahoo.com

Can some one help me to find out how to solve this.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

rahul ahuja12y ago
Thanks for quick reply, if required let you know for the help
Abhishek Kumar12y ago
Hi,

Reference the solution from below link

http://stackoverflow.com/questions/4815836/how-do-you-read-xml-column-in-sql-server-2008

Please let me know if you need more help on this.

Abhishek