maida_rh (10/10/2012)
I tried ur solution but stilll code return the same result as my query return ....
AND NOT (
actiontype in ('withdrawn','Discontinued','Matured','Withdrawn from Public')
AND rhdate < (select getdate()-1095)
)
This will return rows where actiontype is in 'withdrawn','Discontinued','Matured','Withdrawn from Public', but only if they are more recent than 1095 days ago. I think you are getting confused with the logic. Try writing down the rules - for us - it will probably help you too.
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]