InputData

           clientId     securityId TransactionType  TransactionDate
SAPEXTXN7   AS           REL       SELL             06-11-2013  121.1   N
SAPEXTXN7   AS           REL       BUY              06-11-2013  221.1   N
SAPEXTXN7   AS           REL       InPro            06-11-2013  221.1   N
SAPEXTXN7   AS           REL       InStock          06-11-2013  221.1   N
OutPut Data Like

           clientId     securityId TransactionType  TransactionDate
SAPEXTXN7   AS           REL       SELL             06-11-2013  121.1   N
SAPEXTXN7   AS           REL       BUY              06-11-2013  221.1   N

Add a code snippet to your website: www.paste.org