Here are relevant bits , thanks

--bft_4pm_snap 'CHECK','20080205'

CREATE procedure bft_4pm_snap @operation VARCHAR(10),@as_of_dt DATETIME, @return_value int = null output

as

--Declare @operation VARCHAR(10)

--declare @as_of_dt DATETIME

--set @as_of_dt ='20080204'

.

.

.

.

.

.

if @operation ='CHECK'

BEGIN

select @rowcount =...