if statement not working

[junkmail]

if (@salesrepcode = '765') begin

select salesrepcode from orderheader where jobnumber=@jobnumber
@salesrepcode= salesrepcode
end

Msg 102, Level 15, State 1, Procedure fs_enterpriseupdate, Line 62
Incorrect syntax near '@salesrepcode'.

can't seem to figure out what is wrong.

 

[HiTkRdNek]

The problem here isn't with the if statement.. it's with your select statement. You do not have an AND between your two qualifiers.

Where jobnumber=@jobnumber @salesrepcode = salesrepcod

This will always return an error.

 

[mharroff]

Try
select @salesrepcode = salesrepcode from orderheader where jobnumber=@jobnumber

 

[junkmail]

Thanks for the help!