Home > IT Answers > Development > Updating a Date Time Field
DJandLO
130 pts.
 Updating a Date Time Field
Scripts, SQL, SQL 2005, SQL Server, SQL Server 2005
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.

UPDATE

 

ORDERS SET CONFIRMATION_DATE_TIME = NULL WHERE ORDERS.ST_ID = '236477'

Thanks!



Software/Hardware used:
SQL Server 2005
ASKED: August 23, 2011  4:27 PM
UPDATED: March 31, 2012  5:49 PM
RELATED QUESTIONS
Answer Wiki:
You need to update the WHERE portion of the query so that it only impacts the row or rows that you want it to change.
Last Wiki Answer Submitted:  August 23, 2011  8:42 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

DJandLO, if this means that the answer to your previous question was helpful, please take a moment to approve Meandyou‘s answer.

Thanks,

carlosdl
 63,535 pts.
 

Meandyou’s answer didn’t show up on the post but, I clicked thru your comment and was able to view and approve.

thanks

DJandLO
 130 pts.
 

Ultimately I ended up doing:

UPDATE Orders SET Orders.CONFIRMATION_DATE_TIME = NULL
FROM Orders INNER JOIN Meet_Master
On Orders.STATUS = Meet_Master.STATUS
WHERE Meet_Master.MEETING = ‘AM2011′

DJandLO
 130 pts.