January 22, 2009 at 7:34 am
I have a stored proc named Create_Membership_Team where I pass in a database name, so for example if I want to run it, it will look like:
Create_Membership_Team RGTPA --RGTPA is the parameter
I have several to run thru and i want it run all at one time, when I tried to run:
Create Procedure Run_All_Membership
as
EXEC Create_Membership_Team RGTPA
GO
EXEC Create_Membership_Team RHPN
It ran thru the code but didn't create the SP, there are several more lines of this code, this is just a sample, what am I missing?
January 22, 2009 at 7:38 am
Well, for one thing, you cannot have a GO in the middle of a stored procedure. You shouldn't need it either.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 22, 2009 at 7:41 am
I knew it was something simple, no more writing code before my morning cup of coffee, thank you .
January 22, 2009 at 7:49 am
Glad I could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply