Do you have an example that shows your specific problem? I will try to help you out then.

Very concise article.  I spent a couple days figuring this out.  Why is there nothing in BOL as simple as this? 

You might note that to assign the results of the xml-generating query to a variable declared as XML, you need to surround the query in parentheses.

declare @xmlparm xml

select @xmlparm = (select orderid from order for xml auto, type)

OH MY GIDDY AUNT!!!

This article is HUGE!!

Resultset > .NET Serialization > direct Object usage

You can autopopulate an objects list properties with a deserializing use of the resultset.

Have a CurrentOrder object? Derialize the resultset in to it.  I realize I make it sound simple, but if you are creating a system or can fit in some design tweaks/adjustments to the system, then the ability to autopopulate an Order object directly from a result set without need to 'read' the result and load the properies manually?  THAT'S HUGE !!

Its very straightforward. also very practicle.

keep it up......!!!

thanks

That's great. It helped me out a lot.

Does anyone have any info/styles/code/opinions on how to retrieve on the other end?

Specifically how to parse this file into variables in VB.Net?