Rank: Newbie
Joined: 6/19/2009
Posts: 1
Location: Chennai
|
I have the table which has the two fields
CREATE TABLE AgentQueue ( customerId VARCHAR(15) NOT NULL, QueueXML XML NOT NULL )
Queue XMl has the format like
<TransactionResp>
<Queue>
<QueueList customerId="cust123" tokenNumber="218">
<Item Number="1" Name="Srikar12" Date="20090113T1705"/>
<Item Number="2" Name="nikil123" Date="20090113T1705"/>
<Item Number="3" Name="supa123" Date="20090113T1705"/>
</QueueList> </Queue> </TransactionResp>
I am using SQL server 2005.I need the output in below mentioed format using Xquery with in SQL server stored Procedure.
Number Name Date
1 Srikar12 20090113T17052 nikil123 20090113T1705
3 supa123 20090113T1705
Please let me know if any one knows.
|
