Hi All,
I am using below query in Access database to create cross tab query.
TRANSFORM Sum(sn.NAV) AS SumOfNAV
SELECT sn.NavDate
FROM dbo_Scheme AS s LEFT JOIN dbo_Scheme_NAV AS sn ON s.SchemeCode = sn.schemecode
WHERE (((sn.NavDate)>=#1/1/2011#) AND ((s.Active)='Y'))
GROUP BY sn.NavDate, s.Active
ORDER BY s.schemecode
PIVOT s.schemecode;
I want to use the same string in SQl but Transform is not in SQL so how can i use the above string in SQL without transform.
Pls suggest.
I am using below query in Access database to create cross tab query.
TRANSFORM Sum(sn.NAV) AS SumOfNAV
SELECT sn.NavDate
FROM dbo_Scheme AS s LEFT JOIN dbo_Scheme_NAV AS sn ON s.SchemeCode = sn.schemecode
WHERE (((sn.NavDate)>=#1/1/2011#) AND ((s.Active)='Y'))
GROUP BY sn.NavDate, s.Active
ORDER BY s.schemecode
PIVOT s.schemecode;
I want to use the same string in SQl but Transform is not in SQL so how can i use the above string in SQL without transform.
Pls suggest.