Crosstab qry not upsized

My crosstab query did not get upsized using the wizard. What do I need to do
in Access Project to get the same result?
hi John,
"John" <John@.discussions.microsoft.com> ha scritto nel messaggio
news:ABF753FF-80DC-44D9-BDF3-EE8EDA149F11@.microsoft.com...
> My crosstab query did not get upsized using the wizard. What do I need to
do
> in Access Project to get the same result?
SQL Server does not (still) include CROSSTAB query including PIVOT/TRANSFORM
syntax... SQL Server 2005 will include PIVOT/UNPIVOT feature, btu, till it
releases, you have to resort on alternate solution..
SQL Server MVP Itzik Ben Gan released an excellen article about this
(missing) feature, along with a stored procedure to dynamically return
result sets according to specified pivot settings you can read for free at
http://www.winnetmag.com/SQLServer/A...608/15608.html
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You can also take a look at RAC (http://rac4sql.net). It provides similar
syntax for Access users.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2nuarpF4en0iU1@.uni-berlin.de...[vbcol=seagreen]
> hi John,
> "John" <John@.discussions.microsoft.com> ha scritto nel messaggio
> news:ABF753FF-80DC-44D9-BDF3-EE8EDA149F11@.microsoft.com...
to
> do
> SQL Server does not (still) include CROSSTAB query including
PIVOT/TRANSFORM
> syntax... SQL Server 2005 will include PIVOT/UNPIVOT feature, btu, till it
> releases, you have to resort on alternate solution..
> SQL Server MVP Itzik Ben Gan released an excellen article about this
> (missing) feature, along with a stored procedure to dynamically return
> result sets according to specified pivot settings you can read for free at
> http://www.winnetmag.com/SQLServer/A...608/15608.html
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>