Posted by TLetsek on 06/03/05 05:55

Sanjeev's right on the money... user defined function will handle this
nicely.

TLetsek


"Chris Auer" <chris.auer@gmail.com> wrote in message
news:1117740278.709876.4550@o13g2000cwo.googlegroups.com...
> What I am looking to do is use a complicated stored procedure to get
> data for me while in another stored procedure.
>
> Its like a view, but a view you can't pass parameters to.
>
> In essence I would like a sproc that would be like this
>
> Create Procedure NewSproc
> AS
>
> Select * from MAIN_SPROC 'a','b',.....
> WHERE .........
>
>
> Or Delcare Table @TEMP
> @Temp = MAIN_SPROC 'a','b',.....
>
> Any ideas how I could return rows of data from a sproc into another
> sproc and then run a WHERE clause on that data?
>
> Thanks
> Chris Auer
>

• Next in forum: SELECT works but UPDATE fails. ?
• Prev in forum: Printing query results from sp
• Thread view: Re: Getting Data from a storeed procedure in a stored procedure

[Reply to this message]