Re: Pivot Query or Cross Tab queries

I don't believe you can do crosstab queries within SQL Server like you can
in Access
"MChrist" <MChrist@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C5FE6FA4-8AB9-49DE-BA7F-1BD0F226B01A@xxxxxxxxxxxxxxxx
>I can't seem to figure out how to create a cross tab or pivot query on
>data.
> If I was writing the SQL in Access I would write it like
>
> TRANSFORM SUM(DTL.Amount) AS Amount
> SELECT
> STC.ClientID
> , STC.Client
> , STC.SS_ID
> , STC.Region
> , STC.[Sales Director]
> , STC.[Product Consultant]
> , STC.CCC
> FROM (SELECT
> STC.DW_SELLER_ID AS ClientID
> , STC.SELLER_NAME AS Client
> , STC.SS_ID
> , STC.TEAM_ACQ_NAME AS Region
> , STC.ACCOUNT_MANAGER_NAME AS [Sales Director]
> , STC.[Product Consultant]
> , CTC.CLIENT_CENTRIC_CATEGORY_DSCR AS CCC
> FROM dbo.tSeller_Team_Current AS STC
> LEFT JOIN OPENQUERY(SSOT_DWDB,
> 'SELECT DW_CLIENT_ID, CLIENT_CENTRIC_CATEGORY_DSCR
> FROM DW.DW_SALES_CLIENT_TEAM_CURR') AS CTC
> ON STC.DW_SELLER_ID = CTC.DW_CLIENT_ID
> WHERE STC.Channel='RF'
> AND STC.SELLER_ACTIVATION_DATE Is Not Null
> AND SELLER_CLOSED_DATE Is Null) AS STC
> LEFT JOIN dbo.tCRC_Details AS DTL
> ON STC.ClientID=DTL.ClientID
> GROUP BY
> STC.ClientID
> , STC.Client
> , STC.SS_ID
> , STC.Region
> , STC.[Sales Director]
> , STC.[Product Consultant]
> , STC.CCC
> PIVOT DTL.[Description]
>
> How could I write the query so it works in a View?
>
> Thanks in advance.
>
> Mark
>


.

Relevant Pages

  • Pivot Query or Cross Tab queries
    ... I can't seem to figure out how to create a cross tab or pivot query on data. ... , STC.[Product Consultant] ... STC.DW_SELLER_ID AS ClientID ... AND SELLER_CLOSED_DATE Is Null) AS STC ...
    (microsoft.public.sqlserver.mseq)
  • Re: Create databases in a cluster
    ... Not to put too fine a point on it, but if your consultant didn't include ... kills the whole "high availability" reason for a cluster in the first place. ... Stop the SQL server service. ... Add the new disk resource as a dependency of the SQL Service. ...
    (microsoft.public.sqlserver.clustering)
  • Re: View SQL Server Tables in ASP.net/ADO.net
    ... Author, Mentor, Consultant ... Microsoft MVP ... Please reply only to the newsgroup so that others can benefit. ... >I am trying to list the tables in a SQL Server database on an ASP.net page ...
    (microsoft.public.dotnet.framework.adonet)
  • Viescas "Building Access Applications"
    ... Example apps in the books are only .mdb based or some of them are Sql Server ... BELLANTONE MAURIZIO - Teacher, IT Consultant, freelance programmer ...
    (microsoft.public.access.queries)
  • SQL user log on every 30 mins?
    ... is managed by an IT consultant who has remote log in allowed for his user ... program the consultant uses is the SQL Server. ... Is there anything within SQL which could be activatig his user account every ...
    (microsoft.public.sqlserver.setup)