hi, here is my stored procedure
ALTER PROCEDURE [dbo].[legal_register_case]
(
@Name varchar(150) = NULL,
@AgentAddress char(100) = NULL,
@ContactPerson char(200) = NULL,
@ContactNo int = NULL,
@airlineID char(100) = NULL,
@FlightCode char(10)= NULL,
@AirlineContactPerson char(100) = NULL,
@AirlineAddress char(200) = NULL,
@AirlineContactNo int = NULL,
@BrokerName varchar(200) = NULL,
@BContactPerson char(100)= NULL,
@BrokerAddress char(100)= NULL,
@BContactNo int = NULL,
@ConsigneeNo char(10) = NULL,
@ConsigneeName varchar(100)= NULL,
@ConsigneeAdres varchar(200)= NULL,
Go to the complete details ...