I am having trouble with a delete statement that I can't get to work. I am new to SQL and have very limited knowledge so please be kind.
The SQL query will work on a backup table but I can't get it to work on the main table. It seems to work because it doesn't come back with error messages but it says that -0- records have been affected. The two tables are identical as far as I can see (looking at the columns and definitions).
Here is the code:
delete from dbo.Sales
where [Data Date]='12:11:54.0000000' and
I've taken the .0000000 off the time and tried that but that also didn't work.
Any thoughts or help would be greatly appreciated.