471,049 Members | 1,723 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Stored Procdures

49
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.CountOfID
FROM NoOfusers;

(NoOfUsers is a current stored procdure) this didn' twork!
May 22 '07 #1
1 1018
almaz
168 Expert 100+
Please do not create two threads for the same problem. See my answer here.
May 23 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Rhino | last post: by
5 posts views Thread by Tim Marshall | last post: by
2 posts views Thread by Dino L. | last post: by
2 posts views Thread by jed | last post: by
reply views Thread by mirandacascade | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.