rac2:
If I correctly understood your idea, looking at your sp code I belive that you should have to "full-qualify" the names of the objects involved that are external to the db the SP is allocated. That is :
where you used
...SELECT @numberActive = COUNT (PlanID)
FROM plans
i...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.