When you right click on a Stored Procedure and select
About 99% of the code is generated. You have to put a SET statement for each
statement for this stored procedure to work but you did not put code in there to
do that.
Even if you added SET @ = ‘’ than one would
only have to change the ‘’ to a value they want.
This would then be 100% complete. Unless you omitted this for a purpose I am not
thinking of?????