Cacher is the code snippet organizer for pro developers

SELECT dt.uid, dt.transactiontype, dt.netweight, Convert(DATE,dt.timestamp) as DATE, dt.avalue1, CONVERT(INT, dt.nvalue1) as KillNo, *
FROM vw_ce_dms_transactions dt
WHERE UID IN (
select UID
from vw_ce_kp_kill_transactions
WHERE 
	KillTimestamp BETWEEN '2016-06-06' AND '2016-06-12 23:59:59' 
	AND SpeciesCode = 'B'
)
--AND dt.transactiontype in ('KILL_LINE_BEEF_GRADING')
AND Cancelled=0
and todept=30

order by dt.uid