Guys, I'm using SQL Server 2005 and implementing a solution where utilizing the Xml capabilities will prove quite useful.
However, I have a question that I wanted to see if any of y'all knew or would know where I might find some help on. I'm using a PATH mode query (FOR XML PATH syntax) on a query. My problem is that my query is going to get really, really large. I will need to join a single table with 11 other tables and several of those tables will in turn join with other tables. Instead of me trying to build a tremendously large, all encompassing query, I'd like to create smaller queries and then join them together. Does anyone know if that's possible? Thanks, Mike =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
