|
Figure 1. | Here's Why the Upsizing Wizard Winces at Crosstab Queries. The circuitous route from Jet QueryDefs to T-SQL stored procedures and SQL Server crosstab tables is laced with potholes. Automating translation of common TRANSFORM and PIVOT clauses to their T-SQL equivalents and generation of SQL Server objects requires a couple thousand lines of VB6 code, but generating crosstab tables on demand and updating them periodically pays off in far better front-end performance and low back-end resource consumption. |
