Link to home
Start Free TrialLog in
Avatar of Larry Brister
Larry BristerFlag for United States of America

asked on

complex update query

My attached select query works fine

But I need to update CALLDETAIL.dbo.inboundVoiceMail.existsCRM to True
where portal.dbo.FormatPhoneNumber2(sourceNumber) = p.name
Select 	portal.dbo.FormatPhoneNumber2(sourceNumber) sourceNumber, p.name 
	from CALLDETAIL.dbo.inboundVoiceMail
	left join (Select name from crmprod_01.dbo.phone_phones
				group by name) p
				on portal.dbo.FormatPhoneNumber2(sourceNumber) = p.name

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Anuj
Anuj
Flag of India image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sachinpatil10d
sachinpatil10d
Flag of India image
try this

update CALLDETAIL.dbo.inboundVoiceMail 
	set CALLDETAIL.dbo.inboundVoiceMail.existsCRM = 'True'
	from CALLDETAIL.dbo.inboundVoiceMail
	left join (Select name from crmprod_01.dbo.phone_phones
				group by name) p
				on portal.dbo.FormatPhoneNumber2(sourceNumber) = p.name

Open in new window

Avatar of Larry Brister
Larry Brister
Flag of United States of America image

ASKER

WOrked with the exception of changing the left join to a join