SQL Server Performance

Customized SQL Query Anlaysis Services

Discussion in 'Analysis Services/Data Warehousing' started by Hemanth, Oct 5, 2004.

  1. Hemanth New Member


    Dear All,

    Can we have a customized query like this in analysis services.


    SELECT "dbo"."ProductionCompliance"."Category Description",
    left("dbo"."ProductionCompliance"."Adexa Code",5),
    "dbo"."ProductionCompliance"."Production Year-Week",
    "dbo"."ProductionCompliance"."Source Site",
    "dbo"."ProductionCompliance"."Planned", "dbo"."ProductionCompliance"."Confirmed",
    "dbo"."ProductionCompliance"."Adexa Plan", "dbo"."ProductionCompliance"."Actual",
    sum("dbo"."ProductionCompliance"."Min" ) FROM "dbo"."ProductionCompliance"
    GROUP BY "dbo"."ProductionCompliance"."Production Year-Week", "dbo"."ProductionCompliance"."Source Site", left("dbo"."ProductionCompliance"."Adexa Code",5)


    Thanks,

    Hemanth

    Hemanth
  2. Raulie New Member

    Yeah, and probably a lot more.
  3. satya Moderator

    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx for information.
    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page