I have posted this on a couple of Access and SQL Server newsgroups, but with
no answer yet. There seems to be very little activity on the ones I have
looked at, so I thought I would post here as well, since I have no doubt
that many people here also use Access/SQL Server. Anyway, enough of my
rambling and on with the problem/question.
I have two queries that I use in Access:
<qrySelect>
SELECT table2.column1, table2.column2, table2.column3, table1.column4 FROM
table1, table2 WHERE table1.column1 = table2.column1
</qrySelect>
<qryResult>
TRANSFORM First(qrySelect .column3) AS FirstOfCode
SELECT qrySelect.colum n1, qrySelect.colum n4, First(qrySelect .column3) AS
[Total Of Code] FROM qrySelect GROUP BY qrySelect.colum n1, qrySelect.colum n4
PIVOT qrySelect.colum n2
</qryResult>
I now wish to use them against a SQL Server database but I am unfamiliar
with the equivalent construct of Transform/Pivot in SQL Server. I read in
the MS documentation that I should use ROLLUP on the GROUP BY clause, but
try as I might I cannot make it work.
Can any one suggest how this might be done?
If there is a better newsgroup to post this question in I would be grateful
if someone could point me in the right direction.
TIA
Charles Law
no answer yet. There seems to be very little activity on the ones I have
looked at, so I thought I would post here as well, since I have no doubt
that many people here also use Access/SQL Server. Anyway, enough of my
rambling and on with the problem/question.
I have two queries that I use in Access:
<qrySelect>
SELECT table2.column1, table2.column2, table2.column3, table1.column4 FROM
table1, table2 WHERE table1.column1 = table2.column1
</qrySelect>
<qryResult>
TRANSFORM First(qrySelect .column3) AS FirstOfCode
SELECT qrySelect.colum n1, qrySelect.colum n4, First(qrySelect .column3) AS
[Total Of Code] FROM qrySelect GROUP BY qrySelect.colum n1, qrySelect.colum n4
PIVOT qrySelect.colum n2
</qryResult>
I now wish to use them against a SQL Server database but I am unfamiliar
with the equivalent construct of Transform/Pivot in SQL Server. I read in
the MS documentation that I should use ROLLUP on the GROUP BY clause, but
try as I might I cannot make it work.
Can any one suggest how this might be done?
If there is a better newsgroup to post this question in I would be grateful
if someone could point me in the right direction.
TIA
Charles Law
Comment