TR_ADDRESS_INVALIDATE_COORDINATES (Trigger)

                
                    CREATE trigger TR_ADDRESS_INVALIDATE_COORDINATES
                    on dbo.ADDRESS
                    after update
                    not for replication
                    as begin
                        if update(ADDRESSBLOCK) or update(CITY) or update(STATEID) or update(POSTCODE) or update(COUNTRYID) begin
                            delete
                                dbo.ADDRESSCOORDINATES
                            from
                                INSERTED
                            inner join
                                DELETED
                            on
                                DELETED.ID = INSERTED.ID and (
                                DELETED.ADDRESSBLOCK <> INSERTED.ADDRESSBLOCK or
                                DELETED.CITY <> INSERTED.CITY or
                                DELETED.STATEID <> INSERTED.STATEID or (DELETED.STATEID is null and INSERTED.STATEID is not null) or (DELETED.STATEID is not null and INSERTED.STATEID is null) or
                                DELETED.POSTCODE <> INSERTED.POSTCODE or
                                DELETED.COUNTRYID <> INSERTED.COUNTRYID)
                            where
                                ADDRESSCOORDINATES.ADDRESSID = INSERTED.ID;
                        end
                    end