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

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

Date: Mon, 24 May 2004 09:03:08 +0100

Hi Jack

I hadn't come across sqlteam before, but Cor posted a useful link at the
weekend that looks promising, and now that you mention it as well I am going
to pursue it further.

Thanks again.

Charles

"Jack D. Ripper" <steve.nospam.@rac4sql.net> wrote in message
news:%23BuR17TQEHA.2716@tk2msftngp13.phx.gbl...
> "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: MV and SQL
    ... >> finer details than a combination of database constraints and SQL ... If you take away the multivalue feature, ... > handled informally by programmers. ... binding" but they are in some way. ...
    (comp.databases.theory)
  • registry error setting ConfigurationState to SQL_Browser_Redist
    ... I'm trying to install SQL Server 2008 on my corporate Windows XP professional ... ConfigurationState for machine, feature CommonFiles ...
    (microsoft.public.sqlserver.setup)
  • 2008 setup failure Cannot execute a program which is csc.exe
    ... Hi, I downloaded SQL RTM 2008 develpoer edition from MSDN, tried to install ... seems that it was not able to execute csc.exe,here is the last portion of the ... it returned false and true was expected. ... feature is tested for results: ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Sever 2008 RC0 fail to install almost all services
    ... SQL Server\100\Setup ... error, an error reading from installation media, or a problem with this ... The feature is tested for results: ... ConfigurationState for feature SQL_BooksOnline_Redist ...
    (microsoft.public.sqlserver.setup)
  • Re: How to Convert Access Transform/Pivot Query for SQL Server
    ... > The use of CASE implies to me that I would need to code for each case, ... So you are left to build sql case on the dynamaic data present. ... MS does not really want the minor league features in Access in ...
    (microsoft.public.sqlserver.programming)