Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How to assign multiple values to a column?

Answered How to assign multiple values to a column?

  • Monday, February 04, 2013 11:06 PM
     
     
    Sign In to Vote
    0

    How to assign multiple values to a column?

     

All Replies

  • Tuesday, February 05, 2013 2:30 AM
     
     
    Sign In to Vote
    0
    Need more info. What do you mean by column? Can you provide an example? Are you talking about a column in a tablix? in a TSQL query?

    Please Mark posts as answers or helpful so that others can more easily find the answers they seek.

     
  • Tuesday, February 05, 2013 2:59 AM
     
     
    Sign In to Vote
    0

    Hi Tim

    how to show 2 columns values (from dataset) in a single field of a tablix...

     
  • Tuesday, February 05, 2013 11:55 PM
     
     Answered
    Sign In to Vote
    0

    use the expression builder to join the 2 fields:

    =Fields!Field1.Value+", "+Fields!Field2.Value

    The above works for 2 string fields. If Field1 is "XXX" and Field2 is "YYY" then the expression will show "XXX, YYY". If either expression is numeric then wrap it in CStr().

    Please Mark posts as answers or helpful so that others can more easily find the answers they seek.