I have a Stored Procedure without an output parameter but it returns one row always, this SP is called by another SP, so I need to store some of those columns in a variables of the first SP. How can I do that?
P.D.: I have no access to the code of the first SP, and is a CLR, HEEELPPP!!!