• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. Upsizing Jet Applications to... > Emulating Jet Crosstab Queries with ...

Emulating Jet Crosstab Queries with T-SQL

Regardless of your upsizing strategy, you must roll your own T-SQL equivalents of Jet crosstab queries to provide the data source for upsized charts you created with Microsoft Graph and the Chart Wizard. Your only alternative is to convert all graphs and charts to PivotCharts and recreate their source queries.

Jet SQL

This is the generalized Jet SQL syntax for crosstab queries:

TRANSFORM aggregate_function(field_name) [AS alias]
SELECT [ALL|DISTINCT] select_list
   FROM table_name
   PIVOT Format(field_name),"format_type")
  [IN (column_list)]

TRANSFORM defines a crosstab query, and PIVOT specifies the GROUP BY characteristics plus the fixed column names specified by the optional IN predicate.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint