Thanks a lot. However, I solved the problem with the following code: (ReturnsXML is my Table Name and ReturnData is the XML column)

ALTER PROCEDURE [dbo].[GetTDSeDetailsForNonCorpId]

(

@id int

)

AS

DECLARE @x xml;

SET @x =...

I have an XML Column 'ReturnData' and an identity column 'ReturnId' in a table called 'ReturnXML' and I need to get a rowset with columns {EmployerOrDeductorOrCollecterName (varchar), AmtPaid (int), DatePayCred(DateTime),...