Fix Blank Delays

update DelayFIFO
set DelayFIFO.AccountNumber = t.AccountNumber,
DelayFIFO.Class = s.Class,
DelayFIFO.Name = t.PremiseName,
DelayFIFO.ZipCode = a.Zip,
DelayFIFO.GroupID = d.GroupID,
DelayFIFO.BriefDesc = et.BriefDescription
from DelayFIFO u
Inner join AccountMain t on
t.ID = u.AccountID
inner join AccountClass s on
t.ClassID = s.DisplayOrder
inner join AccountAddress a on
a.AccountID = u.AccountID
inner join DealerMain d on
d.DisplayOrder = t.GroupID
inner join EventTypes et on
et.EventType = u.EvtMs
Was this article helpful?
Thank you for your feedback!
User Icon

Thank you! Your comment has been submitted for approval.