Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Advanced
Jul 27, 2004

Retrieve a Concatenated String from One Column of a Table Without Using the Cursor

Sometimes, you need to retrieve a concatenated string from one column of a table without using the cursor. To do this, you can use string aggregation. Here's how:
  1. Create & fill the table using this script:
    
    --
    Create Table Cust(CustID int,CustName varchar(20))
    Insert into Cust Values(1,'Rohit')
    Insert into Cust Values(2,'Amit')
    Insert into Cust Values(3,'Sumit')
    Insert into Cust Values(3,'Punit')
    
  2. Execute this script:
    
    Declare @Names Varchar(2000)
    Select @Names=Isnull(@Names+','+CustName,CustName)
    From Cust
    Select @Names
    
  3. You will get this result:
    
    Rohit,Amit,Sumit,Punit
    
    (1 row(s) affected)
    
Rohit K. Gupta
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date