How do I add a new stored procedure to beerhouse?

Topics: Developer Forum, Project Management Forum, User Forum
Jan 25, 2009 at 2:55 AM
Edited Jan 25, 2009 at 9:15 PM
I've added a new page called Reports, because I want to add a paid subscriber capability to the program. So far, I've got the Report now, and I've added a table Reports, but I keep getting errors when I try to add a stored procedure. I've copied and pasted exact thing from the Newsletter stored procedure, modified just to change name to Reports but I keep getting an error and cannot add it. I'm not that familiar with SQL. I've got VS 2008 and SQL Server 2008. I also tried in SQL management studio but no luck.

EDIT/UPDATE: GOT it working.

Now if I can just figure how to alter it to require payment fist before it goes out.

Anyone able to help me to do this?