Viewing 15 posts - 31 through 45 (of 91 total)
June 26, 2018 at 6:06 am
June 26, 2018 at 5:33 am
Thom A - Tuesday, June 26, 2018 5:24 AMMisunderstood last post.
Yeah! Overlap date and month num 🙂
June 26, 2018 at 5:31 am
Use while loop to generate dates and as Thomas mentioned good to use calendar table.
Here is the query
June 26, 2018 at 5:15 am
Hi Thom A /pietlinden
I'm good with SSRS, As far I know we...
August 23, 2017 at 8:39 am
Phil Parkin - Monday, August 21, 2017 12:07 PMBased on your sample data, what results do you wish to see?
For ID 1...
August 21, 2017 at 12:13 pm
Working fine, Thanks for your help, have a good day,Thanks.
July 24, 2017 at 4:29 am
I would like to ask if there is a possibility for me to...
May 26, 2017 at 7:34 am
Yes correct Livingston, you and chris are masters,kudos to both of you. thanks for your time to read all chat content.????
May 17, 2017 at 10:37 am
sorry looks like some confusion, rule is same ,the code is fine for incident having one schedule
but the problem with multiple schedule , when im using query for real data...
May 17, 2017 at 9:54 am
Nope,why last column data is number 2 for 17:00:00.000000 schedule on 2017-04-28 it should be number 1 beacause it is successfully on 2017-04-27 for 17:00:00.00000 schedule,thanks
May 17, 2017 at 9:41 am
Apologies,
For 2017-04-27 date having two schedules that is 17:00 and 23:00 , 17:00 is executed successfully - result is 0 and 23:00 is not executed- result is 1
For...
May 17, 2017 at 8:43 am
Viewing 15 posts - 31 through 45 (of 91 total)