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:
