Post reply

Query Help - combine multiple rows into single row on select

  • November 13, 2007 at 12:04 pm

    #62587

    Hopefully I can explain this and the answer is easy for the gurus.

    I have a table that has data arranged as follows:

    EventIDNameTimeCaseIDEventType

    1E57AAD5-3A1D-4427-8E6A-0002B2EDB59DFirst Contact38:13.5576E06D9-10A0-4C0D-942F-927B200F86F41

    17AA99A7-8DF4-4405-B13F-0057C367EB20Issue Identified38:42.3576E06D9-10A0-4C0D-942F-927B200F86F42

    2DE88D97-A495-4874-B6F4-5A5A46235EEFCase Created38:11.0576E06D9-10A0-4C0D-942F-927B200F86F40

    CC35A3BB-10AA-482C-8EC6-8908B217E63DResolved39:28.0576E06D9-10A0-4C0D-942F-927B200F86F44

    I'd like to get a Select statement together that could give me the following output from the data.

    CaseIDCaseCreatedFirst ContactIssue IdentifiedResolved

    576E06D9-10A0-4C0D-942F-927B200F86F438:11.038:13.538:42.339:28.0

    So it's basically taking the 4 rows from the table and rolling them all up into a single row.

    I appreciate any insights on how to accomplish this.

    Thanks!

  • November 13, 2007 at 1:00 pm

    #750817

    You are looking for a crosstab report/query. Search here for crosstab or pivot queries or lookup cross-tab report in books online. Post back if you need more help.

  • November 14, 2007 at 6:40 am

    #751066

    Thanks for the bump in the right direction. I was able to get what I needed by using the SP found here: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1131829,00.html

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

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