is it possible in MS SQL to write a stored procdure that uses the FROM statment to get imformation from an existing stored procdure, at the moment i get invaild object as it seem to only like the FROM statment to be a table. I have made sure all the names i'm using are unique. I did a test in access (novis at SQL) an the sql statment it shows just has the query name no reference to wheather it was a table or query, please help, an example would be good.
CREATE PROCEDURE forum2b AS
SELECT NoOfusers.Count OfID
FROM NoOfusers;
(NoOfUsers is a current stored procdure) this didn' twork!
CREATE PROCEDURE forum2b AS
SELECT NoOfusers.Count OfID
FROM NoOfusers;
(NoOfUsers is a current stored procdure) this didn' twork!
Comment