Re: SQL Statement

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

From: Brian P. Hammer (bphammer_at_email.uophx.edu)
Date: 04/20/04 

Date: Tue, 20 Apr 2004 11:55:46 -0500

Thanks Greg - I'll have to check it out. 

-- 
Brian P. Hammer
  "Greg Obleshchuk" <greg-n-o-s-p-a-m-@ag-s-o-f-t-w-a-r-e.com> wrote in message news:OU91kcaJEHA.1220@TK2MSFTNGP11.phx.gbl...
  Hi Brian,
  TRANSFORM is an Access SQL addition .  MS SQL server doesn't support a
  transform extension.
  You should rewrite the SQL using group by queries or you can use a third
  party product
  try this http://www.ag-software.com/xp_ags_crosstab.aspx
  -- 
  Kind regards
  Greg Obleshchuk
  Partner
  A & G Software
  http://www.ag-software.com
  "Brian P. Hammer" <bphammer@email.uophx.edu> wrote in message
  news:#fTeHnXJEHA.4052@TK2MSFTNGP11.phx.gbl...
  Cross Posted  = 3
  All - I have a SQL statement that I used in access and VB.Net to display as
  a pivot table and a chart on a VB form.  I am now in the process of changing
  it all over to SQL data adapters.  I cannot seem to get the Access statement
  to covert over to SQL.  I get an error stating that there is an error at or
  before SoldRetailPrice.  This worked just fine in the Access back end with
  straight ADO code but does not for the Data Adapters.
  Dim sqlPivotData As String = "TRANSFORM
  Avg([SoldRetailPrice]/[AverageEquipmentPrice])" & _
          "AS PercentValue Select YearOfManufacturer FROM tblAircraftRetail
  INNER JOIN " & _
          "tblSoldHistory ON tblAircraftRetail.IDAircraftRetail =
  tblSoldHistory.RetailHistoryID " & _
          "GROUP BY tblAircraftRetail.YearOfManufacturer,
  tblAircraftRetail.IDAircraftRetail " & _
          "PIVOT [YearOfSale]+([QuarterOfSale]/10)"
  Thanks,
  Brian P. Hammer

Relevant Pages

  • Re: SQL Statement
    ... TRANSFORM is an Access SQL addition. ... "Brian P. Hammer" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Statement
    ... TRANSFORM is an Access SQL addition. ... "Brian P. Hammer" wrote in message ...
    (microsoft.public.dotnet.framework.adonet)
  • =?Utf-8?Q?RE:_Frage_zu_SQL_-_Einf=C3=BCgen_von_?= =?Utf-8?Q?Daten?=
    ... "Brian Schmalisch" wrote: ... kann man eine SQL Anweisung so formulieren, ... Auf jeden Fall muss Playername indiziert werden. ... wenn das Constraint verletzt wird und darauf reagieren. ...
    (microsoft.public.de.sqlserver)
  • Re: Simple timeout problem
    ... Brian, I haven't found anything specific on this error. ... We'd want to limit the trace to just the BizTalkRuleEngineDB. ... To run a trace go to SQL Profiler (under the SQL Server entry in the start ... | are reporting a timeout condition trying to connect to the SQL database. ...
    (microsoft.public.biztalk.general)
  • Re: SQL adapter
    ... Brian, do you need to break the data received from SQL into seperate files? ... Think of the Body XPath as the XPath ...
    (microsoft.public.biztalk.general)