Viewing 15 posts - 871 through 885 (of 4,087 total)
Sue_H - Tuesday, October 2, 2018 11:44 AMBut isn't SYSDATE + 1/24/60 an intuitive way to add a minute? 🙂Sue
I don't...
October 2, 2018 at 12:12 pm
Declare @StartDate date = '01-01-2018', @EndDate date = '09-30-2018'
DECLARE @PrevYearStart DATE = DATEADD(YEAR, -1, @StartDate),
@PrevYearEnd DATE = DATEADD(YEAR, -1, @EndDate),
@MonthStart DATE = DATEADD(MONTH,...
October 2, 2018 at 11:55 am
I think it's much simpler. You've posted in an SSRS forum, so presumably you are doing this in SSRS. I also presume that you are using a matrix. In your...
October 1, 2018 at 3:28 pm
Never mind. The OP is asking for the discussion to take place here instead of where I was pointing to.
Drew
October 1, 2018 at 2:00 pm
October 1, 2018 at 1:51 pm
I would use a file system task instead. No need to reinvent the wheel.
Drew
October 1, 2018 at 10:19 am
October 1, 2018 at 7:48 am
September 28, 2018 at 2:06 pm
September 28, 2018 at 9:53 am
September 28, 2018 at 7:55 am
Why do you have parens around your query?
Drew
September 26, 2018 at 2:23 pm
September 26, 2018 at 9:40 am
September 25, 2018 at 12:31 pm
That depends on what UI you are using to display the data. Since you didn't state, I'm assuming you mean in SSMS. SSMS is a development environment, and is not...
September 25, 2018 at 7:41 am
I used a slightly different approach. The problem with the previous approach is that it uses closed intervals (both end points included) when you may need to use half open intervals...
September 21, 2018 at 2:30 pm
Viewing 15 posts - 871 through 885 (of 4,087 total)