get column names from sp

[johnv20]

Hi,
does anyone know how to return the column names returned from a stored procedure.

I've tried sp_MShelpcolumns however while this works fine for tables it returns the required input variables for sps instead ??

 

[vongrunt]

Not possible - for various reasons, including conditional branching (IF this ELSE that) in stored proc.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)