> Yes. It also reminds me why I dislike the graphical execution > plans from MS SQL Server :-)
How does one get a view other than the graphical representation? I poked around a bit but didn't know what to look for... > It looks like eliminating some rows earlier may help here: I implemented your latest version of the query and it actually returned in the same amount of time as your version previous, to the second. But, it is a huge improvement over the way it was when you began offering help, for which I'm grateful. It seems my best permanent solution will be to create a separate db and use DTS to bring the data I need for my reports into a more concise, report-friendly structure, and with your improvements in place the current system will be workable while I work on implementing that. Thanks for helping me learn a few things about sql! -Paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189152 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
