Altova User Support Forum

Welcome Guest

IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Altova User Forums » Members » Nikitha

Profile: Nikitha

About
User Name:	Nikitha
Forum Rank:	Newbie
Real Name:
Location	Chennai
Occupation:
Interests:
Gender:	None Specified

Statistics
Joined:	Friday, June 19, 2009
Last Visit:	Friday, June 19, 2009 6:23:54 AM
Number of Posts:	1 [0.01% of all post / 0.00 posts per day]

Avatar

Last 10 Posts
Topic: Xquery using Sql server 2005 SP Posted: Friday, June 19, 2009 6:08:12 AM
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.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.

user forum