http://www.sqlservercentral.com/Content tagged T-SQL, Stored Procedures, XML, Miscellaneous posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)In the previous articles, Jacob Sebastian looked at using XML to save a sales order with variable numbers of line items to a SQL Server 2000 database. In this part, he expands upon the processing to access that data from multiple nodes. http://www.sqlservercentral.com/articles/Miscellaneous/2911/2007/04/03http://www.sqlservercentral.com/articles/Miscellaneous/2911/In the first part of this series, Jacob Sebastion showed us how to use XML to save a sales order to the database with a variable amount of line items. In part 2, he continues looking at XML in SQL Server 2000 with some advanced XML processing. http://www.sqlservercentral.com/articles/Miscellaneous/2909/2007/03/29http://www.sqlservercentral.com/articles/Miscellaneous/2909/How many times have you tried to save a sales order to your database? For many DBAs this is a common scenario and one of the challenges is the many round trips for the various line items. Jacob Sebastian brings us the first part of a four part series looking at how you can use XML to reduce the round trips in SQL Server 2000. http://www.sqlservercentral.com/articles/Miscellaneous/2908/2007/03/27http://www.sqlservercentral.com/articles/Miscellaneous/2908/A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/