What are the possible values for field transcode?
1) Buy or sell; or
2) Buy, Sell or All
Is 'All' actually a transcode or does all indicate that you want both buys and sells.
Can you can post your question according to these guidelines?
http://www.sqlservercentral.com/articles/Best+Practices/61537/