DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
AsherB 7/24/2012 1:28:17 PM

DD_Year

More articles like this can be found on our SQL Data Access menu.  

It happens (especially in SSRS report writing) that there are quite a few 'parameter' datasets that I find myself writing over and over. We'll document them here and try to end that pain

This is not groundbreaking code, the idea is to develop a library of datasets like this to speed up development. You'll find this and the others on the SQL General menu

This one is the DD_Year stored procedure. As is, it is designed to bring back a data set that holds years from @Start_Year to the current year. If you run it as is it'll bring back three rows, like this:

 

4Penny.net
Version: Unknown or N/A
Section: SQL Scripts