This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:activecounts:sql [2011/01/21 16:32] els |
admin:indexing:activecounts:sql [2011/01/21 16:33] els |
||
|---|---|---|---|
| Line 44: | Line 44: | ||
| As you can see, these SQL statements simple request counts that are filtered by the criteria entered so far, grouped by the next value they want to see. The simplicity of this approach allows it to be more easily integrated into an application. | As you can see, these SQL statements simple request counts that are filtered by the criteria entered so far, grouped by the next value they want to see. The simplicity of this approach allows it to be more easily integrated into an application. | ||
| - | === More Complex SQL === | + | ==== More Complex SQL ==== |
| - | The actual SQL statements for the example on the previous page was slightly more complex, only in that it referenced dimension tables to provide descriptions rather than codes. The actual SQL statements are as follows: | + | The actual SQL statements for the example on the previous page was slightly more complex, only in that it references dimension tables to provide descriptions rather than codes. The actual SQL statements are as follows: |
| First, the presentation of the States: | First, the presentation of the States: | ||