Viewing 15 posts - 2,296 through 2,310 (of 2,648 total)
You can do it in batches so it won't affect other processes:
CREATE INDEX IX_DUMP_JUL2018_1 ON [DUMP_JUL2018] (AGRNO,[VFLAG])
CREATE INDEX IX_SPOOL_1 ON [SPOOL] (AGRNO)
GO
DECLARE @ROWCOUNT...
August 16, 2018 at 4:42 am
August 15, 2018 at 9:49 am
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
Viewing 15 posts - 2,296 through 2,310 (of 2,648 total)