Title: Working now but!
Is there a shorter way to write this or a way to use alias. This is working.
Update [Verification].[dbo].[campaign]
Set [Verification].[dbo].[campaign].DBCompany=[Original_Outbound].[dbo].[campaign].DBCompany,
[Verification].[dbo].[campaign].NeverCallFlag=[Original_Outbound].[dbo].[campaign].NeverCallFlag,
[Verification].[dbo].[campaign].AgentID=[Original_Outbound].[dbo].[campaign].AgentID,
[Verification].[dbo].[campaign].VerificationAgentID=[Original_Outbound].[dbo].[campaign].VerificationAgentID,
[Verification].[dbo].[campaign].CallResultCode=[Original_Outbound].[dbo].[campaign].CallResultCode,
[Verification].[dbo].[campaign].DateTimeofCall=[Original_Outbound].[dbo].[campaign].DateTimeofCall
From [Verification].[dbo].[campaign], [Original_Outbound].[dbo].[campaign]
Where [Original_Outbound].[dbo].[campaign].PhoneNum=[Verification].[dbo].[campaign].PhoneNum
and [Original_Outbound].[dbo].[campaign].CallResultCode=12
and [Original_Outbound].[dbo].[campaign].PhoneNum Is Not Null
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com
