CrossTab Query in T-SQL Will I ever get this right

  • Hi everyone: I have many 4 tables joined in to perform what a crosstab query would do in access. But I can not get it down in T_SQL which I need for ASP page to post on the web as a report. Does anyone have any good T-SQL statements for cross tabs or anything similiar to it. Thanks

  • When you search the site, you'll find several scripts on that topic. My opinion is to do that at your client. With ASP this should be an easy exercise.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

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

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