Help Enclosing Create Procedure In Begin..end

I am trying to enclose a create procedure in a begin...end block and get the following:


Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'PROCEDURE'.

If i execute the create w/o the begin..end it executes correctly. I am at a complete loss. The greater plan is this: when we roll out an updated version of our software we update many things in the database, I need a way to halt and rollback any database changes if there is an error. If anyone has a better suggestion of help with resolving my error I would greatly appreciate it.

Here is my statement:


begin

CREATE PROCEDURE dbo.LMS_InvTurnsEOMUpdate

AS

-- EOM Script to update the InvTurnsEOMCostHistory and InvTurnsEOMInventory tables.

-- these are used for the Inventory Turns Report.

-- Add this script to SQL jobs to run on the last day of the month.

-- kaj 1/08

--exec LMS_InvTurnsEOMUpdate

--select * from InvTurnsEOMCostHistory

--select * from InvTurnsEOMInventory

declare @PeriodID varchar(10)

declare @PeriodDisplaySeq numeric(7,0)

declare @LMSDateCur numeric(7,0)

-- get current system date in NG format

--select cast(getdate() as smalldatetime)

set @LMSDateCur = ((year(getdate())*10000+month(getdate())*100+day(getdate()))-19000000)

-- get period id and period display seq

select @PeriodID = AOAHNB, @PeriodDisplaySeq = AOI4NB

from YAAOREP

where @LMSDATECUR>=AOAADT and @LMSDATECUR <=AOABDT

-- delete everything in InvTurnsEOMCostHistory Table that has a Period ID and Period Display Seq = current

delete from InvTurnsEOMCostHistory where @PeriodID = AOAHNB

-- insert into the InvTurnsEOMCostHistory Table

insert into InvTurnsEOMCostHistory

select ItemPrice.Item_ID, ' ', @PeriodID, @PeriodDisplaySeq,

@LMSDateCur, ItemPrice.ItemPrice_AvgCost, ItemPrice.ItemPrice_PurchaseCost,

ItemPrice.ItemPrice_LastCost, ItemPrice.ItemPrice_StandardCost,

Item.Item_PackMultiple

From ItemPriceMaxDat

Left outer join ItemPrice on ItemPrice.Item_ID = ItemPriceMaxDat.Item_id and

ItemPrice.ItemPrice_DateOfData = ItemPriceMaxDat.ItemPrice_DateOfData

Left outer join Item on ItemPriceMaxDat.Item_ID = Item.Item_Id

Where ItemPrice.CEST='1'



-- delete everything in InvTurnsEOMInventory Table that has a Period ID and Period Display Seq = current

delete from InvTurnsEOMInventory where @PeriodID = AOAHNB



insert into InvTurnsEOMInventory

select WH_ID, Item_ID, @PeriodID, @PeriodDisplaySeq,

@LMSDateCur, ItemWH_BackOrder, ItemWH_OnOrder, ItemWH_Allocated,

ItemWH_OnHand

From ItemWH

Where ItemWh.CEST='1'

end



Thanks,

Sean