Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
Posted Tuesday, July 29, 2014 10:53 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:56 AM
Points: 520, Visits: 1,585
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