Search results for query: *

After a couple of trys in my dev environment & an adjustment it worked! 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' Thanks! DJ

I need to update the Confirmation_Date_Time field to NULL for a specific meeting but am unsure how to insert it. Meet_Master.MEETING is where the meeting code AM2011 is. The script below works for an individual but if they have more than 1 confirmation date it clears then all. UPDATE ORDERS...

Hi SQLBill, Thanks! DJ

I'm just not sure on how to convert the single update string below to be able to update mutiple records (I'm not advanced in code at all) The first set of # (0770, 0665) are the code I want to put on the records (the second set of 3's) UPDATE iweb_conf_demo SET iweb_conf_demo.Attendee_ribbons...

I meant to include this in my post: This is about as far as I've gotten on the update portion. UPDATE iweb_conf_demo SET iweb_conf_demo.Attendee_ribbons = '0770' where (iweb_conf_demo.ID = '219910')

Hi, I'm not totally sure on how to update multiple records with multiple codes so, I'm asking for help. ?(I have an answer on this 1st step so,this is just background info) I need to run an update script to clear out the data from iweb_conf_demo.Attendee_ribbons. ?After I've cleared the...