Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Pre 2012 Stored Procedure: Need some DEV advice (COMPUTE BY TO WITH ROLL UP) Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2014 10:53 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 10:08 PM
Points: 485, Visits: 1,363
Just as a final note for this Stored Procedure...Both Sachin Nandanwar and mister.magoo's advice worked here (the original advice that I thought didn't work actually did end up working once I added the version number change to line 163). A hybrid of the two (simply switching out the COMPUTE SUM line with the SELECT statement), and the change to line 163 has produced the best results for me thus far.

This report is something I do not schedule so I am not as concerned over the SQL Injection attacks mentioned earlier, but best practices definitely dictate that as a needed change, if/when this becomes more automated.

Than you both again for your assistance in helping me get this to work.
Post #1597406
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse