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

From: Jack D. Ripper (steve.nospam._at_rac4sql.net)
Date: 05/24/04 

Date: Sun, 23 May 2004 23:22:32 -0400

"Charles Law" <blank@nowhere.com> wrote in message
news:#R2fd7KQEHA.3532@TK2MSFTNGP12.phx.gbl...
> 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.

So you are left to build sql case on the dynamaic data present.
You can do this then execute the final string,ie. exec(crosstabstatement).
There should be examples on www.sqlteam.com
RAC uses dynamic sql to obtain a solution but does not use multiple
CASE statements.What do you really care about the means to your end:)

> Also, it seems odd that a feature in Access does not have a direct
> equivalent in SQL Server.
MS does not really want the minor league features in Access in
it's 'major' league rdbms.Free of Access constructs leads to a
higher degree of professionalism, or so they think:).

> 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.

The absence of a feature is frequently used to show the theoritical
purity of the product.This is heavily reinforced here with the result
that common sense gets throw out with the bathwater:)

Good luck:)

Relevant Pages

  • Re: How to Convert Access Transform/Pivot Query for SQL Server
    ... weekend that looks promising, and now that you mention it as well I am going ... > So you are left to build sql case on the dynamaic data present. ... it seems odd that a feature in Access does not have a direct ...
    (microsoft.public.sqlserver.programming)
  • Re: Current date as default
    ... implies the table. ... Microsoft IT Academy Program Mentor ... I'm kinda new to SQL and am ...
    (microsoft.public.access.gettingstarted)
  • Re: A pk is *both* a physical and a logical object.
    ... the relational model it is a logical concept. ... standard does not state that a PK implies an index (but I could be ... Indexes are not even part of core sql, so it seems highly unlikely that it is stated that a PK should imply an index. ...
    (comp.databases.theory)
Loading