|
||||
| Close Window |
Free Trial Issue of Visual Studio Magazine
|
|
 |
| Figure 2. | Handle Parameterized Crosstabs With Functions. SQL Server 2000's inline, table-returning functions substitute for views when your crosstab query has one or more parameters. As you can see from this form in the Crosstab.exe project, the resultset has a column for each row header, the column header names, and the values for the intersection of row headers and column headers. You can also use the view or function resultset as the data source for PivotTables and PivotCharts. |