Greetings all - I have a trigger that (I think) I need to break out into two functions. What's happening now is that new records aren't getting sent into my FM_Location table no matter how they're filled in. If you update the record it populates just as you'd expect it to.
My other experiences with these triggers can be found here:
Here is the current trigger:
CREATE TRIGGER FM_Insert_Location
FOR INSERT, UPDATE
i.email_address, i.spbldinf_code, i.spfloors_code, i.spbldrom_code, 'N', GetDate()
from inserted i join deleted d on i.spemp_code = d.spemp_code
where i.spbldrom_code <> d.spbldrom_code and IsNull(i.email_address, '') <> ''