Re: How to Convert Access Transform/Pivot Query for SQL Server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Charles Law (blank_at_nowhere.com)
Date: 05/23/04 

Date: Sun, 23 May 2004 11:15:23 +0100

Hi Uri

Thanks for your reply.

The use of CASE implies to me that I would need to code for each case, when
in fact there are a variable number of cases. The cases are data dependent,
so I could not code for each case.

I am puzzled why I am unable to find any examples of the use of ROLLUP.
Also, it seems odd that a feature in Access does not have a direct
equivalent in SQL Server.

With regard to reports on the client, the manipulation of the data is
speed-sensitive, which is why I am looking to do it at the client. I am
actually trying to populate a grid, and if I retrieve the data and
re-organise it in code it is just too slow.

Any other thoughts?

Charles

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:eUZV7yKQEHA.2704@TK2MSFTNGP10.phx.gbl...
> Charles
> You have to do nothing. There is no tool,script,function to re-write it
for
> you. Look at CASE expression to deal with such kind of queries.
> Also,permit me to suggest you perfoming such reports( if you need to make
a
> report) on the client side.
>
> "Charles Law" <blank@nowhere.com> wrote in message
> news:eT8ZHKFQEHA.3660@tk2msftngp13.phx.gbl...
> > Hi Jack
> >
> > The second reference is closer to the mark because I am looking at a
> > variable number of columns.
> >
> > I'm keen to find out what this ROLLUP thing is all about because MS
> suggest
> > that it is the SQL Server version of TRANSFORM ... PIVOT. But there the
> > trail goes cold. I can't find anything that gives examples of an Access
> > query being re-written for SQL Server using these two constructs.
> >
> > Charles
> >
> >
> > "Jack D. Ripper" <steve.nospam.@rac4sql.net> wrote in message
> > news:%2357TqCDQEHA.2216@TK2MSFTNGP12.phx.gbl...
> > > Ok here's a start:
> > >
> > > http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175574
> > > http://groups.google.com/groups?q=sqlserver+crosstab
> > >
> > > Good luck:)
> > >
> > >
> >
> >
>
>

Relevant Pages

  • no doubt Lenerss striped tear
    ... revival may divert more jails. ... tender node is the client that reports especially. ...
    (sci.crypt)
  • Architecture question
    ... Fairly complex, PCU-intensive reports acessed monthly ... DB server and the network, but the super-expensive reports I think are ... too much to ask a central server and the company's network. ... required on the client machines to generate them (rather than a saved ...
    (microsoft.public.dotnet.general)
  • Re: Client inventory encryption
    ... I will worry about the "unable to verify client ......". ... >> out that report to my secondary site are reporting in correctly....I am ... >>> If the reports are being rejected, it could be that the MP for the ... >>> I think your problem is not encryption but DDR processing. ...
    (microsoft.public.sms.inventory)
  • Web service client, with embedded web server for SOAP callbacks - need clear guidance
    ... I am working on an industrial application that reports data from industrial ... I am working to an industry standard interface spec, ... I have to develop a client to receive the data. ... defines a data collection plan (creates local object, ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: fileevent saying theres something to read but there isnt ?!
    ... fileevent callback requires? ... the upstream client -- you tell the client that data can be read ... This polling is stateless in the ... event stream reports the changes to the master so that they can be ...
    (comp.lang.tcl)