Double Insert Statement Probs

[MATTXtwo]

ALTER PROCEDURE [dbo].[get_user]
(    
    @user_id varchar(8),
    @pwd varchar(12)
    )
AS
 
IF EXISTS(SELECT Personel_No From TblUser_ID where Personel_No = @user_id)
  BEGIN
  IF EXISTS(SELECT Password From TblUser_ID where Personel_No = @user_id AND Password = @pwd)
           BEGIN
INSERT INTO TblAudit_Trails(Personel_No,IC_Baru,Business_Area) 
SELECT Personel_No,IC_Baru,Business_Area 
From TblPeribadi 
WHERE Personel_No = @user_id AND IC_Baru = @pwd
RETURN(3)
           END
  ELSE
           RETURN(1)
  END
ELSE
  BEGIN
  IF EXISTS(SELECT Personel_No From TblPeribadi where Personel_No = @user_id)
    BEGIN
    IF EXISTS(SELECT IC_Baru From TblPeribadi where Personel_No = @user_id AND IC_Baru = @pwd)
        BEGIN
        INSERT INTO TblAudit_Trails(Personel_No,IC_Baru,Business_Area) 
        SELECT Personel_No,IC_Baru,Business_Area 
                    From TblPeribadi 
        WHERE Personel_No = @user_id AND IC_Baru = @pwd
 
                    INSERT INTO TblUser_ID(Personel_No,Password,Update_By) 
        VALUES(@user_id,@pwd,@user_id)
        RETURN(4)
                                END
    ELSE
        RETURN(2)
    END
  ELSE
                RETURN(0)
END
 

//Msg 207, Level 16, State 1, Procedure get_user, Line 15
Invalid column name 'Personel_No'.
Msg 207, Level 16, State 1, Procedure get_user, Line 30
Invalid column name 'Personel_No'.

It appears as my thought cannot be double INSERT statement.but some example of SQL statement that I search for make it successful
So someone please help me..........

[acoder]

Moved to the SQL Server forum (I'm guessing slightly - might belong to Oracle). If it's the wrong forum, could a moderator kindly move it to the correct forum.

@OP, please post your questions in the correct forum. This does not belong in the Feedback forum.

Moderator.

[iburyak]

Check if TblUser_ID has a column Personel_No

It is hard to tell because I don't see your database objects.

Comment out pieces of your code and run it to find which one is having a problem.

Good Luck.

[MATTXtwo]

Check if TblUser_ID has a column Personel_No

It is hard to tell because I don't see your database objects.

Comment out pieces of your code and run it to find which one is having a problem.

Good Luck.

Exactly you're right! I have check it it's my database field name probs.....
Anyway sorry to burst into wrong forum place