Insert Procedure !!

/*
Procedure Name :invoiceInsert
Description : This Procedure is Inserting the Invoice details
Created By: Chandrashekhar Dhingra
Creation Date :25/03/2008
*/

CREATE PROCEDURE invoiceInsert
(
@comdName varchar(50),
@vatD3 varchar(50),
@buyName varchar(50),
@bAddress varchar(500),
@bCity varchar(50),
@bState varchar(50),
@bPincode varchar(20),
@bCountry varchar(50),
@bEcc varchar(50),
@bTin varchar(50),
@conName varchar(50),
@cAddress varchar(500),
@cCity varchar(50),
@cState varchar(50),
@cPincode varchar(50),
@cCountry varchar(50),
@cEcc varchar(50),
@cTin varchar(50),
@ordNo varchar(50),
@ordDate datetime,
@confNo varchar(50),
@conDate datetime,
@rlNo varchar(50),
@rlDate datetime,
@destination varchar(50),
@transport varchar(50),
@transMode varchar(50),
@transTerms varchar(50),
@eCess float,
@tolPac varchar (50),
@she float,
@vat float,
@freight float,
@id int output
)
AS
insert into tblInvoiceDisplay
(
invoice_exComdName,
invoice_vatD3,
invoice_buyName,
invoice_bAddress,
invoice_bCity,
invoice_bState,
invoice_bPincode,
invoice_bCountry,
invoice_bEcc,
invoice_bTin,
invoice_conName,
invoice_cAddress,
invoice_cCity,
invoice_cState,
invoice_cPincode,
invoice_cCountry,
invoice_cEcc,
invoice_cTin,
invoice_ordNo,
invoice_ordDate,
invoice_confNo,
invoice_conDate,
invoice_rlNo,
invoice_rlDate,
invoice_dest,
invoice_transport,
invoice_transMode,
invoice_transTerms,
invoice_eCess,
invoice_tolpacl,
invoice_she,
invoiceAddVar,
invoice_freight
)
Values
(

@comdName,
@vatD3,
@buyName,
@bAddress,
@bCity,
@bState,
@bPincode,
@bCountry,
@bEcc,
@bTin,
@conName,
@cAddress,
@cCity,
@cState,
@cPincode,
@cCountry,
@cEcc,
@cTin,
@ordNo,
@ordDate,
@confNo,
@conDate,
@rlNo,
@rlDate,
@destination,
@transport,
@transMode,
@transTerms,
@eCess,
@tolPac,
@she,
@vat,
@freight
)
Select @id=Max(invoice_id) from tblInvoiceDisplay
GO