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

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Uri Dimant (urid_at_iscar.co.il)
Date: 05/23/04 

Date: Sun, 23 May 2004 13:01:06 +0200

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

  • RE: Alternative program calls
    ... Yes, exactly, I want to pick a table and close any queries and reports, etc. ... And, in this particular situation I am within a macro, ... or is it an issule of permissions at the SQL server or file ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQL Server not recognizing aliased table
    ... SQL Server backends. ... So all my queries have to be Access queries against ... However, when I try to run the reports query, I get an error message: ... Almost all of our mdb's hit the SQL Server for reports. ...
    (microsoft.public.access.queries)
  • Re: Counting, summing, matching, summing again...
    ... Create Views, Stored Procs, and UDF's on your Sql server to handle ALL of ... Then use Access ADO, DAO, PassThru queries, or ... > I build reports that show data such as how many people from a census table ... I learned to do this all with queries ...
    (microsoft.public.access.forms)
  • Re: Access DB Upgrade
    ... I have an existing Access DB that consists of tables, forms, queries and reports. ... I need to get it online and into SQL server, what is the quickest and best way to do this? ...
    (microsoft.public.dotnet.languages.vb)
  • Missing Statistics - sysindexes.rows = 0 for ClusteredIndex on 5 million row table.
    ... All queries are operating - just very slowly. ... We cannot get SQL Server ... but rows still reports 0. ... DBCC CHECKDB & DBCC CHECKCATALOG report no problems. ...
    (microsoft.public.sqlserver.server)