DECLARE @AgentQueue TABLE  ( customerId VARCHAR(15) NOT NULL,	QueueXML XML NOT NULL )
INSERT INTO @AgentQueue
SELECT '1', '<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>'

SELECT 
t.c.value ('@Number[1]','varchar(50)') AS Number,
t.c.value ('@Name[1]','varchar(50)') AS Name,
t.c.value ('@Date[1]','varchar(50)') AS Date 
FROM @AgentQueue agent
   CROSS APPLY
 QueueXML.nodes('/TransactionResp/Queue/QueueList/Item') as t(c)

/*Result set

Number	 Name 		   Date
1	Srikar12	20090113T1705
2	nikil123	20090113T1705
3	supa123		20090113T1705
*/