Direct Reports
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Direct Reports
| Line 17: | Line 17: | ||
</pre> | </pre> | ||
| - | This is an example of | + | This is an example of an ANSI SQL recursive query. Recursive queries have the general format: |
| + | |||
| + | <pre> | ||
| + | WITH view_table AS ( | ||
| + | SELECT ... | ||
| + | UNION ALL | ||
| + | SELECT ... | ||
| + | JOIN view_table ON connect_criteria | ||
| + | ) | ||
| + | SELECT ... | ||
| + | FROM view_table | ||
| + | WHERE | ||
| + | start_node_criteria | ||
| + | </pre> | ||
| + | |||
[[Microsoft SQL Server]] | [[Microsoft SQL Server]] | ||
