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_Month stored procedure. As is, it is designed to bring back a data set that holds 12 months. If you run it you'll see this:
