WITH AccItem AS (

SELECT itemId,

ROW_NUMBER() OVER (ORDER BY dt) AS rnAll,

ROW_NUMBER() OVER (PARTITION BY itemId...

Thanks for all of the replies, and thanks andrewd. Your query seems to be what I am looking for.. I'm unable to test at the moment but will test it...

any insight would be greatly appreciated, thanks.