@andycadley 
Can i ask that if i wanted to apply...

Thank you andycadley, this is wonderful. So simple yet so overlooked........

Thanks for your reply. To clarify i'm not looking to put formulas into columns...I appreciate your concern with other sites.

The goal is to provide a row with...

Hello sgmunson,

It was actually decided to not change security...

Hi Lowell,

Thank you for the insight, I actually found the resolution which was actually on a reddit thread.

https://www.reddit.com/r/SQLServer/comments/4rd5kg/sql_server_2016_database_mail_and_net_35_framework/

You don't need to install...

Thank you very much for the redirect, i'm going to try to apply this tomorrow but i will post the result, this certainly looks like where i can to go...

Hello!

Thank you for the reply I will certainly take a look.

My dataset is not as clean but I think I can make it work. Example: a user can have...

Hi Jeff,

Fair question and at this point i'm not sure if this is something i need however what the end goal is to get a listing using start_date, effective_date (date...

Thank you very much! i didn't think to use a function, i do already have a date dimension table.

the solution worked using the following code for those who need as...

Hi ChrisM@work and others!

It seems that the output from this query was great for the customers and now they are asking to expand it and once again i would like...

hi again,

i dont mean to bump this thread up again but the output was great for the use and additional scope has been added. To use a graphing tool...

okay, wow well thank you all for your queries, i learnt something new with each one, the last query outputs the data in the format i'm exactly looking for :)...

Thank you dwain.c, i'm working through the query now to under stand it (pretty complicated 🙂

hi Chris.m below is the sample data as well as my expected output (sorry i...

Hi salamex,

Thank you, this query is very similar to my first query and it works great if the car is in "service/shop" on the same day, the problem i ran...

well i found a bug with the code posted and that is it doesn't include records that stay longer than a day...

so back to square one.