Sreepathi1987 (2/26/2015)
How can get this result with out using CTE. using CTE I got. But i need with out CTEbecause there are other conditions and need to append with that queries.
Why do you think using a CTE would prevent any of that?
--Jeff Moden
Change is inevitable... Change for the better is not.