Your question, your audience. Choose who sees your identity—and your question—with question security.
SELECT t.PART_ID, t.TRANSACTION_DATE , t.CLASS
FROM dbo.INVENTORY_TRANS t
WHERE t.PART_ID IS NOT NULL
AND t.TRANSACTION_DATE = ( SELECT MAX(i.TRANSACTION_DATE) FROM dbo.INVENTORY_TRANS i WHERE i.PART_ID = t.PART_ID )
ORDER BY PART_ID
select t.* from dbo.inventory_trans t
join
(select part_id, transaction_date, transaction_id, row_number() over (partition by part_id order by transaction_date desc, transaction_id desc) rn
from dbo. inventory_trans
where class in ('I','R')
) tm
on t.transaction_id = tm.transaction_id
and tm.rn=1
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
FROM dbo.INVENTORY_TRANS
WHERE (NOT (PART_ID IS NULL))
GROUP BY PART_ID