pilla.sree85 (7/17/2014)
Till now i am good.then how would i check the condition duplicate count >1 then i need to execute query for further processing in order to display output as Duplicate
If you have finished modifying the last query I sent you, then post it here and folks will show you how to proceed.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden