Viewing 15 posts - 2,296 through 2,310 (of 2,645 total)
I am trying to do a pattern search and my query is generic and...
August 15, 2018 at 9:20 am
August 15, 2018 at 8:12 am
August 15, 2018 at 7:19 am
But I don't think he wants a...
August 15, 2018 at 5:49 am
If you can export it as '="0000"'
August 15, 2018 at 5:30 am
;WITH CTE AS
(
SELECT DISTINCT
Staff.Person_id,
Staff.Forename,
Staff.Midname,
Staff.Surname
FROM Staff_Report AS...
August 15, 2018 at 4:51 am
August 14, 2018 at 11:03 am
August 13, 2018 at 3:34 am
August 12, 2018 at 2:57 am
I don't think anyone has noticed/seen my solution above. You just need to use LEFT(CounterDateTime, 23) and it will work!
So Daniel can just use:delete from [dbo].[CounterData] WHERE...
August 11, 2018 at 5:41 pm
I've had to query the CounterData table before.
I use LEFT(CounterDateTime, 23) and it works ok.
I think the 24th character is something like a file terminator.
August 10, 2018 at 9:37 am
I'm testing some new backup processes here (a weekly job and a daily job).
I...
August 10, 2018 at 6:09 am
August 9, 2018 at 8:39 am
Viewing 15 posts - 2,296 through 2,310 (of 2,645 total)