If the CustID key is in TEST_CUSTOMERS table but not in TEST_COMBINED
table, then I want to add a row with that key, and also put the 
CustDate in both the Date1 and Date2 columns.  Notice than the 
purpose of the query is to add CustID keys that are in TEST_CUSTOMERS 
TABLE but missing from TEST_COMBINED.  Any existing row in 
TEST_COMBINED is left alone. 


TEST_CUSTOMERS table:

CustID--CustDate---------------
AAAAAA--2012-09-05 00:00:00.000
BBBBBB--2012-09-05 00:00:00.000
DDDDDD--2012-09-05 00:00:00.000



TEST_COMBINED table:

CustID--Date1-------------------Date2-----------------
BBBBBB--2012-12-18 00:00:00.000|2012-12-18 00:00:00.000
CCCCCC--2012-12-18 00:00:00.000|2012-12-18 00:00:00.000
EEEEEE--2012-12-18 00:00:00.000|2012-12-18 00:00:00.000


What I want to see:

TEST_COMBINED table:

CustID--Date1-------------------Date2-----------------
AAAAAA--2012-09-05 00:00:00.000|2012-09-05 00:00:00.000
BBBBBB--2012-12-18 00:00:00.000|2012-12-18 00:00:00.000
CCCCCC--2012-12-18 00:00:00.000|2012-12-18 00:00:00.000
DDDDDD--2012-09-05 00:00:00.000|2012-09-05 00:00:00.000
EEEEEE--2012-12-18 00:00:00.000|2012-12-18 00:00:00.000


Here are scripts to create the data:

USE [Northwind]
GO
/****** Object:  Table [dbo].[TEST_COMBINED]    Script Date: 11/26/2012 16:18:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TEST_COMBINED](
	[CustID] [nvarchar](6) NULL,
	[Date1] [datetime] NULL,
	[Date2] [datetime] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[TEST_COMBINED] ([CustID], [Date1], [Date2]) VALUES (N'BBBBBB', CAST(0x0000A12B00000000 AS DateTime), CAST

(0x0000A12B00000000 AS DateTime))
INSERT [dbo].[TEST_COMBINED] ([CustID], [Date1], [Date2]) VALUES (N'CCCCCC', CAST(0x0000A12B00000000 AS DateTime), CAST

(0x0000A12B00000000 AS DateTime))
INSERT [dbo].[TEST_COMBINED] ([CustID], [Date1], [Date2]) VALUES (N'EEEEEE', CAST(0x0000A12B00000000 AS DateTime), CAST

(0x0000A12B00000000 AS DateTime))
/****** Object:  Table [dbo].[TEST_CUSTOMERS]    Script Date: 11/26/2012 16:18:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TEST_CUSTOMERS](
	[CustID] [nvarchar](6) NULL,
	[CustDate] [datetime] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[TEST_CUSTOMERS] ([CustID], [CustDate]) VALUES (N'AAAAAA', CAST(0x0000A0C300000000 AS DateTime))
INSERT [dbo].[TEST_CUSTOMERS] ([CustID], [CustDate]) VALUES (N'BBBBBB', CAST(0x0000A0C300000000 AS DateTime))
INSERT [dbo].[TEST_CUSTOMERS] ([CustID], [CustDate]) VALUES (N'DDDDDD', CAST(0x0000A0C300000000 AS DateTime))

quote:

---

Originally posted by chadmat

INSERT INTO TEST_COMBINED
SELECT CustID, CustDate, CustDate
FROM TEST_CUSTOMERS
WHERE CustID NOT IN (SELECT CustID FROM TEST_COMBINED)

-Chad

---