Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Query Question

Respondida Query Question

  • Tuesday, March 13, 2012 6:12 AM
     
     
    Sign In to Vote
    0

    I'll start by saying I am very new to this.

    I am trying to query a DB where I have the same column with multiple data for the same record and I would like to display all of the data available in a single record rather than having the data duplicated multiple times to display the different entries (hope this makes some sense to someone)

    Example:

    The following columns always display the same data for the one record and don't need to be duplicated:

    [Record] [Date] [UserID] [Team] [Status]

    However the following field also needs to be displayed, but currently when I query it - it causes the previous mentioned fields to be duplicated and this column could have 7 or 8 different entries in it:

    [Journal]

    If anyone understands what I mean and has an idea how I can make it so it displays as one record I would very much appriciate it.

    Example:

    [Record] [Date] [UserID] [Team] [Status] [Journal1] [Journal2] [Journal3] [Journal4] [Journal5] etc.

     

All Replies