Hi, I don't have a sample procedure as of now, but you could certainly refer this article http://www.sqlservercentral.com/articles/XML/62290/, and also maybe refer this http://msdn.microsoft.com/en-us/library/ms190945.aspx, where they give some examples on the same XML code that you've got up there... Regards

Indika, SQL Server 2005 introduced the XML data type, which can be used to pass your object into the stored procedure. Within the stored procedure you could use XQuery functions (which are supported by SQL Server 2005) to manipulate the value passed to it. Regards

This post is to discuss and rate the article Constructing XML using FOR XML by Harshana Weerasinghe.[Poll]