Viewing 15 posts - 5,041 through 5,055 (of 13,872 total)
i wonder why executing a TRUNCATE and INSERT INTO Command is mutch slower than ...
October 12, 2017 at 9:20 am
October 12, 2017 at 9:10 am
October 12, 2017 at 9:04 am
I tend to cheat even more.
DECLARE @RunDate DATE = '10/02/17'
...
October 12, 2017 at 8:18 am
So your requirement is to create a table of date ranges?
What happens if there are 50 rows with the same date?
October 12, 2017 at 6:59 am
You can cheat a bit here, Phil. DATENAME can replace your CAST.
[code...
October 12, 2017 at 6:01 am
What is your question?
October 12, 2017 at 5:09 am
October 11, 2017 at 2:25 pm
October 11, 2017 at 1:28 pm
Note also that the FORMAT() function is renowned for being a slow performer, so I don't recommend this for large record sets.
October 11, 2017 at 1:25 pm
October 11, 2017 at 1:23 pm
Within a Foreach loop, I have a simple Script Task to check if a...
October 11, 2017 at 12:00 pm
Viewing 15 posts - 5,041 through 5,055 (of 13,872 total)