<div>
Output needed for the above data will be ?
</div>


Output needed for the above data will be ?

<div>
<div class="content wysiwyg-content">
I have data like this &nbsp;in the table. I want to extract records which do not have record type cancel in that record id’s last record and if a record has cancelled and renewed again it should only show the records from renewal row to end.<br />
<br />
Please let me know how can this be accomplished?<br />
<br />
<br />
<br />
A111 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;New &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br />
A111 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cancel &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br />
A111 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Renew &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3<br />
A111 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Change &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4<br />
A112 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;New &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br />
A112 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Change &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br />
A112 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Change &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3<br />
A113 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;New &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br />
A113 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cancel &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br />
A114 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;New &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br />
A114 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cancel &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br />
A114 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Renew &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3<br />
A114 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Change &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4<br />
A114 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cancel &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5
</div>
</div>


I have data like this  in the table. I want to extract records which do not have record type cancel in that record id’s last record and if a record has cancelled and renewed again it should only show the records from renewal row to end.

Please let me know how can this be accomplished?



A111	New	1
A111	Cancel	2
A111	Renew	3
A111	Change	4
A112	New	1
A112	Change	2
A112	Change	3
A113	New	1
A113	Cancel	2
A114	New	1
A114	Cancel	2
A114	Renew	3
A114	Change	4
A114	Cancel	5

Record extraction

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.