DECLARE @tableROllAPoll TABLE
(
IndividualID BIGINT,
matchname VARCHAR(1000),
matchaddres VARCHAR(1000),
matchEmail VARCHAR(1000),
HomeNumber BIGINT,
Mobile BIGINT,
matchOP VARCHAR(1000),
MatchAll_IndividualID BIGINT,
NamePhoneEmail_IndividualID BIGINT,
NamePhoneAddress_IndividualID BIGINT,
NameAddressEmail_IndividualID BIGINT,
PhoneAddressEmail_IndividualID BIGINT,
NamePhone_IndividualID BIGINT,
NameEmail_IndividualID BIGINT,
PhoneEmail_IndividualID BIGINT
);
DECLARE @tableActiveRecords TABLE
(
OriginID INT,
OriginName VARCHAR(1000),
IndividualID BIGINT,
matchname VARCHAR(1000),
matchaddres VARCHAR(1000),
matchEmail VARCHAR(1000),
HomeNumber BIGINT,
Mobile BIGINT
);
UPDATE rp
SET rp.NamePhoneEmail_IndividualID = namephoneemail.IndividualID
FROM @tableROllAPoll rp
JOIN @tableActiveRecords namephoneemail ON rp.matchname = namephoneemail.matchname
AND rp.matchEmail = namephoneemail.matchEmail
AND rp.Mobile = namephoneemail.Mobile
AND rp.Mobile > 0;
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE