Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
Begin /* Call procedure to Update a record into the Entity Table */ If @tiEntityType = 2 /*Individual */ Begin /* Ensure that fields not provided on the Contact page do not wipe out existing data. For example, if Address3 is not provided on the "Add Contact to Vehicle page" BUT it DOES have a value in the Entity table, then this update would wipe out the Address3 value!*/ select e.vchAddress2, e.vchAddress3, e.vchFaxNumber, e.vchSpecialNote1 from dbo.Entity e where e.iEntityId = @iEntityid; Exec @iReturnValue = DSuEntity @iSiteId, @iEntityid, /*iEntityId will get set on Insert from Identity Column' */ @tiEntityType, /*Company = 1 and Individual = 2*/ @vchCompanyName, @vchSalutation, @chGender, @vchFirstName, @vchMiddleName, @vchLastName, @vchAddress1, e.vchAddress2, /* from the select statement above */ e.vchAddress3, /* from the select statement above */ @vchCity, ... ...
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.