Using SQL 2008 and 2005
Think this is where Dense rank may need to be used
There are only for rows in this sample but there may be more
Based on Email address I need to roll up the values to replace the nulls with the one with the latest entry
Rules roll up to latest email
then roll up latest values to that email
I have included 2 examples 1 in each tab..