Thanks for the answer. There's one bit of information I missed off the supplied sql which is kinda important...
The select includes a date range e.g.

select * from sysaudits_01 where suid in (1,2,3,4,5) and eventtime > '
+$suppliedtime'
union
.
.
[download]

This therefore doesn't lend itself to using a stored proc solution since due to the variable timestamp input the sql is ever changing.
Thanks to you for your answer and the others who have shared there wisdom. As always there are many ways to skin a cat !