Post reply

cross-tab alternative in sql

  • March 20, 2009 at 10:31 am

    #128818

    Now i have this query

    TRANSFORM Sum(tbl1.col1) AS SumOfcol1

    SELECT tbl1.col2,

    tbl1.col3 FROM tbl1

    WHERE tbl1.col2 = "Z01" GROUP BY tbl1.col2, tbl1.col3 PIVOT tbl1.col4

    Can we have the alternative of this cross-tab query (MSAccess)

    changed to the SQL version.

    I know i have not given data..however can we try and change the statement in sql. Please....

    Thanks..

  • March 20, 2009 at 10:36 am

    #963671

    I can't answer your immediate question, however, Jeff Moden has written some extensive articles here on SQLServerCentral and I would recommend taking a look at them first.

    start here:

    http://www.sqlservercentral.com/articles/T-SQL/63681/

    best of luck and tgif,

    alan

  • March 20, 2009 at 10:39 am

    #963673

    also if you give us an example of some data then we could help you.

    I don't understand the syntax you have pasted so I'm not 100% sure what you pivoting.

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply