• I tried getting the job names to pivot somehow in SQL 2000 (as we have a legacy server running it still...), but I gave up after a while too.

    The closest I got to the original "pivoted" data was posted a bit further up in this thread: http://www.sqlservercentral.com/Forums/FindPost1414190.aspx.

    A google search for SQL 2000 pivot brings up a few contenders for a solution.

    Best of luck, and if anyone manages to solve it, please post the code here for others to use!