I need to put a row number count to a report. As long as the results of my query only come back with one row per IN I'm fine. My problem comes into play when I have multliply lines of info for one item. example for a I.IN i could have more then one j.body brought back, when I look at the results I get skipped numbers because my row numbers are based on IN. I have to do the count by the IN column. How can I get my numbers not to skip when displaying the results. I put a copy of my select below.
row_number() over(order by i.in) as row_number
FROM I INNER JOIN J ON J.P_R = I.R
WHERE (I.Createdate >= GETDATE() - 1) (I.CC <> 'xyz') ORDER BY I.CreateDate