[RESOLVED] Update record on SQL

[mlosso]

I am using MS SQL SERVER 2000 with a PERL SCRIPT.

UPDATE [CustSat].Customers_T
	SET [CustSat].[Customers_T].LastEmailSent = GETDATE(),[CustSat].[Customers_T].LastTicketSent = TicketAssignment_T.TicketNumber
	SELECT TOP $survey_total TicketAssignment_T.Customer_ID, TicketNumber, LanID, EmailAddress, ShortDescription
	FROM TicketAssignment_T
	INNER JOIN Customers_T
	ON (TicketAssignment_T.Customer_ID = Customers_T.Customer_ID)
	WHERE((DATEDIFF(day,Customers_T.LastEmailSent, GETDATE()) > $customer_days) OR (Customers_T.LastTicketSent IS NULL))
	ORDER BY NEWID()

Where ever you see a $ is a variable from a perl script.


Anyways, what the code is supposed to do is just update the TOP #, which are selected randomly by used ORDER BY NEWID(), and update those values with the current date. Instead, it is updating every row in the table with the current date. How could I change this?