Viewing 11 posts - 1 through 11 (of 11 total)
August 14, 2018 at 2:00 am
Hi John
Yes, i can made the comparisons but the problem is to delete oldest data.
The method i used is not the best but works. This...
August 10, 2018 at 9:50 am
August 10, 2018 at 9:31 am
August 10, 2018 at 9:26 am
Hi
I have created a workaround:
...
if month(getdate()) = '9'
delete FROM dbo.CounterData WHERE CounterDateTime like '%-07-%'
go
if month(getdate()) = '10'
delete FROM dbo.CounterData...
August 10, 2018 at 9:23 am
August 10, 2018 at 6:51 am
laurie-789651 - Thursday, August 9, 2018 10:08 AMIs this a locale issue? What country are you in?
Hi, It´s not a local issue....
August 10, 2018 at 2:05 am
August 9, 2018 at 9:46 am
Hi John
When i run the statement
SELECT counterdatetime
FROM CounterData
WHERE TRY_CONVERT(datetime,counterdatetime) IS NULL
August 9, 2018 at 9:44 am
Hi John Thank you
Now something is missing me.
When i run this:
delete from [dbo].[CounterData]
where counterdatetime IN
(
SELECT counterdatetime
FROM CounterData
...
August 9, 2018 at 9:16 am
Hello Laurie
Thanks for the reply 🙂
The date appears this way when i made a select:
CounterDateTime
2018-08-09 13:34:47.626
The column is (CHAR(24), not null)
August 9, 2018 at 7:59 am
Viewing 11 posts - 1 through 11 (of 11 total)