Kingston Dhasian (4/26/2013)
Is it possible for TransactionID to be duplicated in the table GV_Voucher?If the answer is No, then you can fetch it based on VoucherNo's else you will need TransactionID in both the tables.
ye sTransactionID is duplicate in table Gv_voucher and voucherno is unique
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/