select * from tbEntity with(nolock)
where EntityID = 4834


select top 100 * from tbTransactionTransfer with(nolock)
where TransferFromEntityID = 875
order by 1 desc

-- denied
select * from tbTransactionTransferDetail with(nolock)
where TransactionTransferID = 264437

update tbTransactionTransferDetail set Comment = 'Someone dropped it!'
where TransactionTransferID = 264437 and ItemID = 577

update tbTransactionTransferDetail set Comment = null
where TransactionTransferID = 264437 and ItemID = 577

-- accepted
select * from tbTransactionTransferDetail with(nolock)
where TransactionTransferID = 264436


--264437
--264436

select * from tbTransactionTransfer with(nolock) where TransactionTransferID = 264437

update tbTransactionTransfer set PartialTransferId = 264436 
where TransactionTransferID = 264437

update tbTransactionTransfer set PartialTransferId = 264437 
where TransactionTransferID = 264436

-- reset
update tbTransactionTransfer set PartialTransferId = null
where TransactionTransferID in(264436, 264437)



