Viewing 15 posts - 5,056 through 5,070 (of 13,879 total)
I tend to cheat even more.
DECLARE @RunDate DATE = '10/02/17'
...
October 12, 2017 at 8:18 am
October 12, 2017 at 8:06 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 2:08 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
October 11, 2017 at 11:23 am
Have you tried stepping through the code in debug mode? Maybe that will throw some light on the issue.
October 11, 2017 at 10:48 am
October 11, 2017 at 10:36 am
Can you give us some examples ... a couple which work and a couple which do not, perhaps? Do certain delimiters always work and others not?
Or (the scary scenario!) are...
October 11, 2017 at 6:01 am
Viewing 15 posts - 5,056 through 5,070 (of 13,879 total)