quote:

---

Originally posted by ATG

I'm trying to append to a field using a switch. What I want it to do is check several fields for a data, and if they dont have them, append a message. Here is my sample code. I think I'm close but can't seem to get it.

ALTER PROCEDURE CheckSubcontractField
@Company varchar(10),
@Job varchar(10),
@SL varchar(10)
as

update SLHD set SLHD.udVerifyField=SLHD.udVerifyField +
CASE
when (SLHD.PayTerms is null) then 'Pay Terms' ELSE '' END +
CASE when (JCJMPM.udSuperintendent is null) then 'Superintendent not entered' ELSE '' END +
CASE when (JCJMPM.ProjectMgr is null) then 'PM not entered' ELSE '' END + CASE when (JCJMPM.udPrjAcct is null) then 'PA not entered' ELSE '' END


from JCJMPM JCJMPM (Nolock)
LEFT JOIN PMPM PM (Nolock) on PM.ContactCode=JCJMPM.ProjectMgr and PM.VendorGroup=JCJMPM.VendorGroup
LEFT JOIN PMPM Super (Nolock) on Super.ContactCode=JCJMPM.udSuperintendent and Super.VendorGroup=JCJMPM.VendorGroup
LEFT JOIN PMPM PA (Nolock) on PA.ContactCode=JCJMPM.udPrjAcct and PA.VendorGroup=JCJMPM.VendorGroup
LEFT JOIN SLHDPM SLHD (Nolock) on SLHD.Job=JCJMPM.Job and SLHD.JCCo=JCJMPM.JCCo and SLHD.VendorGroup=JCJMPM.VendorGroup
LEFT JOIN PMSS PMSS (Nolock) on PMSS.SL=SLHD.SL and PMSS.VendorGroup=SLHD.VendorGroup

where (JCJMPM.Job=@Job and JCJMPM.JCCo=@Company and SLHD.SL=@SL) and (JCJMPM.udSuperintendent is null)

---