I know its probably an easy question but I am trying to create a stored procedure to get the last ten years from a table in my database so that I can then show them on my View in an MVC asp.net application.
            Asked
            
        
        
            Active
            
        
            Viewed 64 times
        
    0
            
            
         
    
    
        marc_s
        
- 732,580
- 175
- 1,330
- 1,459
1 Answers
0
            
            
        For this you would need to have a date field for each row, otherwise there is no way of knowing when a record was inserted.
 
    
    
        Waidmann
        
- 74
- 2
- 
                    i have a row called Year with a lot of files in it.. but i just need to get the current year and 10 years back – May 15 '20 at 17:05