You can also build up a query as a string within your Stored procedure and then use the EXEC function executing the string .....
Phil Sayers <[EMAIL PROTECTED]> wrote: Views are you friend. create views that each do 4 or 5 joins making sure you SELECT the fields you need. then use those views in your main query. but if you need all the jons, then you may have to resign yourself to "this is what it takes to get the results as defined by requirements" so you go ahead and do it. :) -----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] Behalf Of Mike Andrews Sent: Thursday, August 10, 2006 2:16 PM To: [email protected] Subject: [ADVANCED-DOTNET] SQL Server 2005 Xml question... 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 =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com --------------------------------- Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail Beta. =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
