Generating Missing Dates and Numbers (SQL Server Central)
This article presents an approach to generate missing numbers and dates without using a temp table. I do not intend to claim that this approach is better than the others. There is no programming approach that suites all requirements. Based on the specific application scenario a certain approach may be found suitable than the others. I guess some of you may find this approach easier to integrate into your application specific requirements.
Resources: code1.sql code2.sql code3.sql code4.sql
No comments:
Post a Comment