I've been whining a lot lately about how SQL Server 2008 (and none of the other SQL Server's)
have a generate_series() function that I have grown to love in PostgreSQL. Admittedly I've just been too lazy to
create one even though its not that difficult of a task.
Simon Greener over at Spatial DBAdvisor heard my whining and I guess got fed up enough
to create a generate_series() function for SQL Server 2008.
He also has a generate_series function for Oracle too by the way.
Now there are a couple of differences between the way you use it in the 3 databases which are caused
by fundamental differences between the architectures of the 3 databases.
Continue reading "Chocolate and Peanut Butter Cross-Breeding with PostgreSQL, SQL Server 2008, and Oracle"