Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2009-06-18 : 21:23:44
|
| Hello All,I have a table shown below, that stores XML values into XML_Text. Once the user specifies the type_id and the date field in the stored procedure, I want the xml in the xml_text field to be converted into a table. Record_ID Type_ID date Cost XML_Text5D968EEC-D801-4BE4-8369-4D0A94213986 2 6/18/09 15:44 6 5D968EEC-D801-4BE4-8369-4D0A94213986 3 6/18/09 3:44 205 Below are xml that can be stored into the xml_text field.Type_ID = 2<XML_Field> <XML_Field_Date>C6C5DF0F-11F8-41AE-96AD-26BF883EA588</XML_Field_Date> <Detail_Date>06/18/2009</Detail_Date> <TAX_ID>000-00-0011</TAX_ID> <name_count>2</name_count></XML_Field><XML_Field> <XML_Field_Date>04BAD53A-325C-4002-BCCC-46A8FD96DA3D</XML_Field_Date> <Detail_Date>06/18/2009</Detail_Date> <TAX_ID>00-0000123</TAX_ID> <name_count>2</name_count></XML_Field>Type_ID = 3<XML_Field> <XML_Field_Date>31A634CD-4559-4989-80DE-F1C6C1AFFB2C</XML_Field_Date> <Detail_Date>06/18/2009</Detail_Date> <C_ID>2000269343</ C_ID > <TAX_ID> - - </TAX_ID> <LAST_NAME>Sean Sanders</LAST_NAME> <EMS_EN_TYPE>PER</ EMS_EN_TYPE > <TABLE_ID>1046</TABLE_ID> <ADDED>20070112115904</ADDED></XML_Field>Please advice. Thanks. |
|
|
|
|
|
How to pass parameter to a stored procedure that u