How To Modify My Stored Procedure So That...

Hi,


Below is the SP that I want to modify it such that it does another thing apart from what its doing now. I want to to delete all the records corresponding to the BpDate value before this insert happens. by meaning deleting all the records, I meant to say delete all records where BpDate = @BpDate and SiteCode = @SiteCode.








CREATE PROC CabsSchedule_Save





@JulianDate smallint,


@SiteCode smallint,


@BpDate smallint,


@CalendarDay smallint,


@BillPeriod smallint,


@WorkDay smallint,


@CalDayBillRcvd varchar(30),


@Remarks varchar(50)





AS








INSERT INTO


CabsSchedule(JulianDate, SiteCode, BpDate, CalendarDay, BillPeriod, WorkDay, CalDayBillRcvd, Remarks)


VALUES


(@JulianDate, @SiteCode, @BpDate, @CalendarDay, @BillPeriod, @WorkDay, @CalDayBillRcvd, @Remarks)


GO














Any help will be appreciated.





Thanks,