Have you tried the MS Access Syntax ? - e.g.:

TRANSFORM Sum(cube_by_c.netc_bd) AS [Summe von netc_bd]
SELECT cube_by_c.pthr_product_c AS PROD_C, xref_prod.pthr_desc_x AS [DESC]
FROM cube_by_c LEFT JOIN xref_prod ON cube_by_c.pthr_product_c =
xref_prod.pthr_product_c
WHERE (((cube_by_c.country_iso3_c)="DEU"))
GROUP BY cube_by_c.pthr_product_c, xref_prod.pthr_desc_x
PIVOT cube_by_c.yyyymm;

regards,
markus



"Sommai Fongnamthip" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
> MySQL has a method to write Crosstab method but It can't use with MS
> SQL.  Did someone know how to write SQL statement for make cross tab with
> MS SQL 6.5 (both ODBC and TDS connection)?
>
> Thank you
> SF
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to