• Unless i dont understand the question, can you just add the variable you want to see in the output of the stored proc ?

    eg


    select col1, col2, col3, @var1, @var2
    from table1