Ok, but if it is a one off thing, then queries are generally fine but if it is not a one off then I would recommend SSRS reports and use the email feature to create them off hours.
Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802 www.Enhansoft.com<http://www.enhansoft.com/> [Description: Description: cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/> Enhancing Your Business [Description: Description: Description: Description: Description: Description: Description: cid:image004.png@01CD5E19.F3C3A110]<http://be.enhansoft.com/>[Description: Description: Description: Description: Description: Description: Description: cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: Description: Description: Description: Description: Description: Description: cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Enhansoft's YouTube Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: Description: Description: Description: Description: Description: cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/> [cid:image007.png@01CFA365.5C9D22A0]<http://mms.mnscug.org/> Ask Me About Our Free SSRS Reports<http://www.enhansoft.com/pages/Free-SSRS-Reports.aspx> From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Poole, Richard Sent: Friday, July 18, 2014 6:20 PM To: mssms@lists.myitforum.com Subject: [mssms] Reports vs queries Happy Friday everyone, I unfortunately have someone in upper management that has been through the ropes with SMS 1.0-2003. They keep wanting reports from various things, but think all these custom requests are simple because all he knows is going into queries and pulling the data from there. I’ve been working from 2007-2012 and I thought the philosophy behind queries was that they pegged the SMSProvider and to not use them other than developing lists that could be used in collections. Is there any documentation on this being the case? My next plan of attack is to then use performance monitoring and run one of the queries I swear brings the server to its knees. Thanks in advance, Richard Poole