I need to update the Confirmation Date Time field to NULL for a specific meeting but am unsure how to insert it. The script below works for an individual but if they have more than 1 confirmation date it clears then all.
Meet_Master.MEETING is where the meeting code AM2011 is.
ORDERS SET CONFIRMATION_DATE_TIME = NULL WHERE ORDERS.ST_ID = '236477'
SQL Server 2005
August 23, 2011 4:27 PM
March 31, 2012 5:49 PM