In my database I have 3 fields that I'm working from
Now someone asked to add on the report "order of Dependents based on age" which I did, but now they want a Dep# (ordered by age) starting from the number 1. So they want it to look like this.
Does anyone have an example on how to do this?
Thank you in advance.
So on SQL Server 2005 and above you can use a
This query should provide exactly your results.
answered Oct 20 '11 at 10:26 PM