CREATE TABLE #t1(OrderId INT PRIMARY, src VARCHAR(50),Campaign VARCHAR(50))
INSERT INTO #t1(OrderId,src)
SELECT o.OrderId, src FROM CustomerInfo.dbo.Analytics_Campaign_Info(NOLOCK) AS aci
INNER JOIN Diapers.dbo.orders(NOLOCK) AS o ON aci.OrderId=o.OrderId
WHERE o.OrderDate BETWEEN '2011-08-08 00:00:00' AND GETDATE()
UPDATE a
SET a.src=b.Campaign,a.Campaign = b.src
FROM
CustomerInfo.dbo.Analytics_Campaign_Info a
INNER JOIN #t1 b ON a.OrderId=b.OrderId
INSERT INTO #t1(OrderId,src)
SELECT o.OrderId, src FROM CustomerInfo.dbo.Analytics_Campaign_Info(NOLOCK) AS aci
INNER JOIN Diapers.dbo.orders(NOLOCK) AS o ON aci.OrderId=o.OrderId
WHERE o.OrderDate BETWEEN '2011-08-08 00:00:00' AND GETDATE()
UPDATE a
SET a.src=b.Campaign,a.Campaign = b.src
FROM
CustomerInfo.dbo.Analytics_Campaign_Info a
INNER JOIN #t1 b ON a.OrderId=b.OrderId