SQL Server Derived Tables

added by BlackWasp
6/14/2012 8:32:59 AM

4 Kicks, 339 Views

Some result sets are difficult to extract from a database without performing multiple queries or using temporary tables and cursors, which can harm performance. Derived tables help with some problems by creating virtual tables within the scope of a query.


2 comments

dpeterson
6/14/2012 8:27:36 AM
I've never actually taken the time to learn the name for this query method, but it has been the single greatest productivity/efficiency boost I've ever gotten with SQL. It really lets you start digging in and wrangling much larger amounts of data from many more places. It's also extremely useful in the aggregate situations that you demonstrated.

timbolt8
6/18/2012 10:21:58 AM
Those are some pretty interesting queries. Not a huge DBA fan or anything, but I do like this!