is there any way to make a stored procedure within the scope of a stored procedure? ie ,

create/alter proc _

as

create/alter proc #_

as

exec #_

thanks,

I looked it up, and max is only for 2005 (I'm using 2000).

I can use text type instead.

Would it be better to execute the input from a file or via...

Hmm I think this didn't compile because you replaced # with @

try this:

you can't define tables using '@', you must use '#'?

create

 proc dbo

solution:

CREATE TABLE #t(v varchar(100))--columns&column metadata must match resultset of query

INSERT

#t EXEC

are stored procedures selectable?

ie...

create proc dbo.sp

as

select * from tableA where

col in(   ( select col from (select exec spB)  )   )