Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Pre 2012 Stored Procedure: Need some DEV advice (COMPUTE BY TO WITH ROLL UP) RE: Pre 2012 Stored Procedure: Need some DEV advice (COMPUTE BY TO WITH ROLL UP)

  • Sachin - thank you for starting things out here with this logic. I appreciate it! I am still getting compile errors (though it will make the Stored Procedure now) in that the bracketed columns are showing to be invalid. When I try to run it after compiling it, it comes back with the following error:

    Msg 50000, Level 16, State 1, Procedure sp_SOS, Line 259

    No records were found macthcing your criteria.

    There definitely are matching records, so I once again am - stuck.