UPDATE [Directory].dbo.Archive
SET Archive.ArchiveDescription = 
( SELECT DISTINCT EMPLOYEEID
	FROM [BILLINGTEST].[dbo].[TEMP_USERS]
	INNER JOIN Directory.dbo.MailboxEntry
	ON Directory.dbo.MailboxEntry.ADMbxDN = billingtest.dbo.TEMP_users.DISName)
	WHERE [Directory].[dbo].[MailboxEntry].ADMbxDN=[BILLINGTEST].[dbo].[TEMP_USERS].DISNAME)
WHERE EXISTS
( SELECT DISTINCT DISNAME
	FROM [BILLINGTEST].[dbo].[TEMP_USERS]
	INNER JOIN Directory.dbo.MailboxEntry
	ON Directory.dbo.MailboxEntry.ADMbxDN = billingtest.dbo.TEMP_users.DISNAME
	WHERE [BILLINGTEST].[dbo].[TEMP_USERS].DISNAME = [Directory].[dbo].[MailboxEntry].[ADMbxDN]);

quote:

---

Msg 512, Level 16, State 1, Line 9
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

---

CREATE TABLE [BILLINGTEST].[dbo].[TEMP_USERS]
(   DISNAME NVARCHAR(255) NULL,
    EMPLOYEEID  NVARCHAR(255) NULL
);

BULK INSERT [BILLINGTEST].[dbo].[TEMP_USERS] FROM 'e:\billing\users.txt' 
WITH ( FIELDTERMINATOR ='|', FIRSTROW = 2 )

UPDATE Users 
SET Users.Description = 
( SELECT TEMP_Users.EMPLOYEEID
	FROM TEMP_Users
	WHERE TEMP_Users.DISNAME = Users.DN) 
		WHERE EXISTS
		( SELECT TEMP_Users.DISNAME
			FROM TEMP_Users
			WHERE TEMP_Users.DISName = Users.DN); 

DROP TABLE [BILLINGTEST].[dbo].[TEMP_USERS]

UPDATE 
	U
SET 
	Description = T.EmployeeID
FROM
	Users AS U
INNER JOIN
	TEMP_Users AS T
	ON T.DISNAME = U.DN

quote:

---

Originally posted by Lamprey

Ahh I see. There are several ways to do that. I belive this will work for you:

UPDATE 
	U
SET 
	Description = T.EmployeeID
FROM
	Users AS U
INNER JOIN
	TEMP_Users AS T
	ON T.DISNAME = U.DN

---

ON.T.DISNAME = U.DN

ON T.DISNAME = database.dbo.ExchangeMailboxEntry.DN