Try cursor

I think you can try a cursor for that. Means first take the values into cursor from your procedure and then chk out it in the loop accordingly.

something like;

DECLARE get_values CURSOR FOR ( exec spu_SdOtherNews )

OPEN get_values

FETCH NEXT FROM get_values into @variables as per your procedure;

WHILE @@FETCH_STATUS = 0

////////in this loop you can use it.

FETCH NEXT FROM get_values into @variables as per your procedure;

end

CLOSE get_values

DEALLOCATE get_values

I am not sure will this help you or not , but i think this is one way to solve your problem.

Try it.

Best Luck!!!!!!!!!!!!!!!!!
Sujit.