Error in inserting values into database

Hi..

Am using stored procedure in my project, am trying to insert combo box values into the project, it is inserting value into the table but not to the proper column.. And i ve mention proper column name also in a Query.. Stored procedure code is like dis..

Code:

---

CREATE Procedure usp_liTeIn(@sku varchar(64),@dt char(10),@type char(1),@adSlNo int,@EnqFor char(2),@AdSlNoFor int,@Enquiry varchar(1000),@CuEnqNo varchar(64),@CEDt char(10),@Worth numeric(12,2),@HandBy int,@TargetDt Char(10),@EpSlNo int,@UsSlNo int,@slno int,@SpName varchar(100)= null)  as

Begin
    Declare @numrows int,@errno int,@errmsg  varchar(255), @error int,@date datetime,@CuEnqDt dateTime,@tDt DateTime,@MaxId int
       
      SET NOCOUNT ON
      SET DATEFORMAT MDy
      SET @date    = @Dt
      SET @CuEnqDt = @CEDt
      SEt  @TDt        = @TargetDt
           


     
        EXECUTE usp_GenerateID 'tEnquiry','TeSlNo',@MaxID OUTPUT       
       
        if @MaxID <= 0
          begin 
            select @error = 40000, @errmsg = 'Error On Key Generation ' +                          convert(char(10),@errno)
            goto error           
        End

        /* Insert a new record into TEnquiry Table */

        Insert TEnquiry (TeSlNo,TeSku,TeDate,TeType,TeAdSlNo,TeEnqFor,TeAdSlNoFor,TeEnquiry,TeCuEnqNo,TeCuEnqDt,TeEntDt,TeUpDt,teStatus,TeWorth,TeHandBy,TeTargetDt,TeEpSlNo,TeUsSlNo,TeSpName)
        values (@MaxId,@Sku,@Date,@Type,@adSlno,@EnqFor,@AdSlNoFor,@Enquiry,@CuEnqNo,@CuEnqDt,getDate(),getDate(),'',@Worth,@HandBy,@tDt,@EpSlNo,@UsSlNo,@SpName)
       
        Select @numrows = @@rowcount,@errno = @@error               
        if @errno <> 0 or @numrows = 0
          begin             
            select @error = 30000, @errmsg = 'Error On Insert ' + convert(char(10),@errno)
            goto error           
        End


end
return 0
/*  errors handling  */
error:
  Begin
    raiserror @error @errmsg   
    rollback  transaction
    return 
end
GO

---

Here am trying to insert value into TeSpName column but it is inserting into TeEpSlNo column.. help me..

Have you tried PRINT'ing out the value of @EpSlNo? Perhaps it's receiving the same value as @SpName?