Try this,let me know if the below is what you are looking for(you can go back any number of days with date part)
 

            
June 13, 2017 at 11:13 pm
            
#1946680

            
            
                                                
        

[font="Courier New"]

Here is an example of the recursive query.We usually use these types of queries to loop over and generate results

Generally a CTE is used and then joined with the...

" Select StaffID,'Phone1'=

(case when HomePriority=1 then home

when CellPriority=1 then Cell

when AlternatePriority=1 then Alternate else null end),

'Phone1Type'=(case when HomePriority=1 then...