Click here to Skip to main content
14,575,874 members

combinig more then two columns data into one temporary column.

ntitish asked:

Open original thread
how can i combine more then two columns data into one temporary column

actually i joined two tables that looks like this
-------------------------------------------------------------------------
First_Name  Email_Id              City        State        industry_type  
nitish      pvss341@gmail.com    vijayawada    AP            IT
TEJA        TEJA341@gmail.com    vijayawada    AP            IT
MANI        MANI341@gmail.com    vijayawada    AP            IT



//BY USING BELOW QUERY I GOT THIS TABLE

select r.First_Name,r.Email_Id,r.City,r.State,e.industry_type
from Registration as r
inner join Experience_Detail as e
on r.Login_Id=e.Login_Id


NOW I WANT THE RESULT SHOULD BE LIKE THIS BELOW TABLE
-----------------------------------------------------------------------------

First_Name  Email_Id              City        State industry_type  FullDetails  
nitish      pvss341@gmail.com    vijayawada    AP     IT       [by-nitish,email_id,
TEJA        TEJA341@gmail.com    vijayawada    AP     IT        vijayawada,AP,IT]  
MANI        MANI341@gmail.com    vijayawada    AP     IT


[edit]Code block added - OriginalGriff[/edit]
Tags: SQL-Server (SQL-Server-2005)

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
  4. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100