HWY IVE CREATED A STORED PROCEDURE IN SQL 2005. IT IS EXECUTING WITHOUT ANY ERROR. NOW CAN SOME TELL ME THE SYNTAX FOR RUNNING AND TESTING THIS STORED PROCEDURE. IT HAS THE FOLLOWING INPUT PARAMETERS FROM THE UI START DATE END DATE 5 RADIOBUTTONS WITH YES/NO COULD U GIV A COMPLETE SYNTAX WITH INPUT PARAMETERS. THANKS JUSTIN

http://databases.about.com/od/sqlserver/a/storedprocedure.htmMy Blog "Karl Beran's BI Mumble"

http://msdn.microsoft.com/en-us/library/ms188332.aspxMy Blog "Karl Beran's BI Mumble"