SQL Create Stored Procedure

create procedure Camp_Sales

as

begin

update [dbo].[TBL_Campaign_Records] set call_status=1,Call_Result_Last_Status=99

where Created_DateTime=DATEADD(day, DATEDIFF(day, 0, GETDATE()),0) and call_status=0 and Call_Result_Last_Status=1 and Campaign_ID=31

end

go