Hi,
I urgently need to create the following in SQL:
Delete
all records
from
Bocs.dbo.stats_one
where
TimeStamp is older than 24 hours and
Code begins with "CC"
I’m not a million miles away I think!...I have the following where I am selecting:
I need to change the select to delete but I don’t know how to do the “TimeStamp is older than 24 hours” bit..
Can anyone help?
Thanks.
Ah dinnae ken...
I urgently need to create the following in SQL:
Delete
all records
from
Bocs.dbo.stats_one
where
TimeStamp is older than 24 hours and
Code begins with "CC"
I’m not a million miles away I think!...I have the following where I am selecting:
Code:
SELECT * FROM Bocs.dbo.stats_one WHERE LEFT(Code, 2) = 'CC' and TimeStamp = ' ';
I need to change the select to delete but I don’t know how to do the “TimeStamp is older than 24 hours” bit..
Can anyone help?
Thanks.
Ah dinnae ken...