Andras,

Thanks for your input. That worked a treat.

Stuart

John,

Great stuff. Thanks for your help.

Stuart

Just a thought - Is there a system sp that returns the col definitions for a given stored procedure?

John,

Thanks for your reply and your suggestions

I'm not sure that I can modify the SP's directly. 

However, I am interested in the dynamic SQL approach.  You stated 'How about creating...

Gents,

Thanks for your replies.

However, i'm still a little confused.

insert table1

exec mysp1

I get the following error: Invalid object name 'table1'.

I'm assuming that this is because I havent declared or created table1...