Initially sql server would not concatenate the EMPLID and EMPL_RCD fields as they are different datatypes. This particular statement sums the goal of what I am trying to accomplish however it takes too long to process and I am thinking that an easier method has to exist.

I have to concatenate the EMPLID and EMPL_RCD fields because the empl_rcd field determines an emplid with multiple jobs in my system and I only want to update where the emloyees job is specific to my criteria.

SwePesoNew Member

13 Mar 2009 02:21 AM

quote:Originally posted by: g8rIt will work, but you'd be better off using an inner join between the tables on the two fields.