need store procedure in sql server 2008.

Hi,

correct my undertanding, In store procedure you want to perform Insert operation in two table and delete operation on one table.

Create Store procedure Test
(
    @date datetime,
    @productname  varchar(50),
    @price float,
    @extra float
)
AS
begin
 declare @total float = (@price+@extra)
 declare @vat float = 14.5
 declare @netamount float = @total + (@total*@Vat/100)

 Insert into table1(date,productname,price,extra,toatl,vat,netamount)
        values(@date,@productname,@price,@extra,@toatl,@vat,@netamount)

Insert into table2 (date,productname,price,vat,total)
values (@date,@productname,@price,@vat,@netamount)

-- write delete code here...
end

Also we are not clearly get you quesition please provide more information