nR01qT9p

1IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ODSCustomerContact]') AND type in (N'U'))
2DROP TABLE [ODSCustomerContact]
3Go
4Create Table ODSCustomerContact 
5(CustomerContactInt int NOT NULL identity PRIMARY KEY,
6ClientName          nvarchar(30) NULL,
7ContactFirstName        nvarchar(60) NULL,
8ContactLastName         nvarchar(60) NULL,
9Position                nvarchar(30) NULL,
10Phone               nvarchar(30) NULL,
11MobilePhone         nvarchar(30) NULL,
12EmailAddress        nvarchar(30) NULL)
13	
14insert into sec_ods.dbo.ODSCustomerContact
15
16select d.SoldToShortName as Clientname, 
17  e.FirstName as Contact_FirstName, 
18  e.LastName as Contact_LastName ,
19  e.Position,
20  e.Phone,
21  e.MobilePhone,
22  e.EmailAddr as EmailAdress
23
24from projectrule d
25left join BusinessEntityAssociation BEA 
26on d.soldtoID = BEA.customerID 
27left join BusinessEntityContact e 
28on e.BusinessEntityID = BEA.BusinessEntityID 
29
30where d.SoldToShortName IS NOT NULL