Posted by NiTiN on 09/11/06 07:54

Hi!

I'm a new T-SQL developer and just hit a roadblock.

I have a scenario that goes like this: I have 2 stored procedures,
spInner and spOuter. spInner has a SELECT statement which would
normally be used by a class using MS Enterprise Library and that output
goes into a DataSet. However, I need to get the output of the SELECT
statement to go into spOuter and that's what I can't seem to figure
out.

I know I may be asked to use functions that return tables in replies to
this post, but I can't do that as some parts of my application have an
EXEC(string) for dynamic SQL, instead of spInner.

Any help appreciated.

Cheers,
N.I.T.I.N.

• Next in forum: Re: Passing SELECTed rows to a calling SP
• Prev in forum: ANN: Advanced Data Generator 1.7.0 released
• Thread view: Passing SELECTed rows to a calling SP

[Reply to this message]