itsyourssankalpa (5/29/2016)
That works. I used cross apply and then created two new temp table that didn't have time in the resulting table from cross apply, and joined those two for the remainder. Thank you for the help. And yes, using greater than was intentional, we didn't need data for the first 30 minutes, but needed data from the 31st min of the time-slab.
glad to hear you have solved it....for the benefit of others who may come across this post in the future, would you care to share your solution.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day