Jeff Moden (6/27/2016)
Nomvula (6/27/2016)
thank you so much J Livingston SQL,it worked perfectly!!!
Since you're the one that needs to support it, the question now is... can you? Do you actually understand how it works?
suggest you read this article as well as the one I pointed you to in the code
http://blogs.solidq.com/en/sqlserver/packing-intervals/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day