December 24, 2016 at 8:31 am
That is a great idea. Thanks for the post
December 24, 2016 at 8:33 am
This is interesting. How did you come up with this?
December 24, 2016 at 8:35 am
Right you are. It is fairly specific for their needs.
December 24, 2016 at 8:36 am
I like the idea of removing the case. It is something I will remember in the future. Thanks for the idea.
December 24, 2016 at 8:38 am
I have not used the ABS function but that seems like a great use of it.
December 24, 2016 at 8:41 am
It is not bullet proof for sure and it is specific for them as their shifts stand today. But tomorrow they could easily decide to change it all up and this approach might not work.
December 24, 2016 at 8:51 am
I appreciate all the comments so far. It is great to be able to see the different ways to accomplish the same tasks. And I did end up making it a function :).
December 24, 2016 at 9:04 am
I will add a suggestion that you always use 1/1/1753 07:00 as the basedate. That way there is no need to worry about which date is larger. 🙂
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
December 24, 2016 at 9:11 am
Good point.
December 24, 2016 at 9:13 am
The code could be very well be wrong. What would you suggest as a fix?
Viewing 10 posts - 16 through 24 (of 24 total)
You must be logged in to reply to this topic. Login to reply