SQL Express query question. I have a field in a table that says NULL, I need that to be changed to a date. My query process but doesn't make the change.
Posted on 2011-02-28
I have a problem with a sql table. It has date field in about 200 of 2000 records. I don't know how it happened yet, but to correct the problem so work can conntinue I need to do two things.
1. Update the 200 records to have the correct date.
2. Empty another table so all 2000 records can be processed through without duplication.
My query to change the field from NULL to the date is "UPDATE Usage SET TransDate='2011-03-01 00:00:00.000' WHERE TransDate=NULL" This query processes but says no records processed. I need assistance with this query.
I also need assistance correctly emptying a table. All data in my arimporttable needs to be emptied.
I do not usually write the queries, this is an urgent fix needed and I need some assistance.
Thank you, Sharon