Updating a Date Time Field

130 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    DJandLO, if this means that the answer to your previous question was helpful, please take a moment to approve Meandyou's answer. Thanks,
    69,510 pointsBadges:
    report
  • DJandLO
    Meandyou's answer didn't show up on the post but, I clicked thru your comment and was able to view and approve. thanks
    130 pointsBadges:
    report
  • DJandLO
    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'
    130 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following