Drop all that in a procedure declaration as such:

CREATE PROCEDURE usp_MyProcedure

(

    @sParam1 varchar(100),

    @sParam2 varchar(100),

    @sParam3 varchar(100)

)

AS

... [INSERT PROCEDURE CODE HERE] ...

As far as storing the value from your...

are you trying to do this once in a while or every time an sp fires?

http://support.microsoft.com/default.aspx?scid=kb;en-us;247527

(you added a period)

although the thread went a little off topic i do have a comment about the US. If you are young and have no college but (like me) have progressed from...