Performance Improvement for Cursors in Stored Procedures

Background on this example This is a fairly simple example, but is from a real world stored procedure.  The procedure accumulates the special instructions for all tasks assigned to a department and outputs them as a single string.  In this application, each job is assigned multiple tasks required to complete the job and each of […]

Read More »