Hi Scott,

Many thanks for sharing the above solution, I've tested it out and it works perfectly fine while handling durations but when I calculated ToTs for each sales person the...

Thanks Thom. Got your point. : )  Let me change the expected result set along with sample data itself.

Does this make sense now?

CREATE TABLE TestData ([Time Off...

Yes, those are the only one I can get. I know it is ridiculous but if someone gets 10 days off then he/she has two options.

1- Select "Long Absence" and...

@thom-2 A, @scottpletcher, Many thanks for your replies. Data comes from one of the downstream services (CRM). The way how they keep dates is odd enough...

Figured this out. : ) Since I already have"Time" column, I don't have to calculate End Dates for each row. I have combined the following queries. Basically, the first one...

• This reply was modified 5 years, 7 months ago by  seismicbeat. Reason: Typo

The above query would possibly work if I manage to add business days to the Start Date but excluding weekends. Let's say ten days from start date but excluding weekends.

Start...

rVadim, you're right. I've created a sample data but forgot to change the table name. I've just modified the script. Sorry for the inconvenience caused.

Thanks

• This reply was modified 5 years, 7 months ago by  seismicbeat. Reason: Typo

Hi Luis,

Actually, there are certain ToT selections that return NULL in the end date column and to get around this I'm using dateadd to update end date based on value...

@pietlinden, @jonathan-2, thank you so much for your help.

I've set up the delimiter and tested it out with the sample data you've shared above. So, it...

Hi Jeff and Lynn,

Basically I failed to provide every possible detail to help you out, sorry for that. 🙁

@Lynn,

I actually...

Hi Lynn,

Thank you for the reply. 🙂

As I previously mentioned that the above table is what I came up with after combining the separate data from...

@desnorton, @luis Cazares, @jason A. Long, Thank you so much for your answers in great details to my question. You are kind enough to...

@desnorton, that's exactly what I want to do, I really appreciate for your help. 🙂

Any ideas/comments? I tried to provide the sample data in a correct way to facilitate things, but if not please tell me, so that I can fix it. 🙂