Hi Divya, it gud..

you just can minimize the query length a little by removing the highlighted text...

SELECT *,

(SELECT CASE

WHEN (SUM(CASE WHEN B.DEDate =1

THEN 1 ELSE 0

END AS isawk

from PersonRecord B CROSS JOIN PersonRecord C

WHERE B.PersonID=A.PersonID

AND C.PersonID=A.PersonID

AND B.VERSION<>C.VERSION

AND B.VERSION<C.VERSION) AS [Is ImProper]

from PersonRecord A