(Lucas Jellema) Row generation is a very useful technique for many (semi-)advanced SQL Queries. We have discussed various methods for row-generation in previous articles on our weblog. Examples are the CUBE operator, Table Functions and the Connect By Level < #number of records approach, apart from
[membership level="0"]
[pmpro_button level="14" text="Read More - Register for Free Membership"][/membership]
[membership][standout-css3-button href="http://technology.amis.nl/blog/?p=2419" opennewwindow=true]Read More[/standout-css3-button] (Community content)
[/membership]
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help