I have gone through the entore thread. Could you please tell me how my solution is so suboptimal. Will it not work in any condition or will it be having...

Posted comment on Comparision of Dates in SQL looks fine. But as written above, it may not be the best solution in case of using indexes. Well... while comparing two...