Return comma seperated values from multiple record

It helps you in situaions whenever you wish to create commm seperated values actually originating from multiple records. Say, your query return three records in folloing patter:Student_Name=============RickyAdamMathewBut, say you wish to have records in following patter:Student_Name============Ricky, Adam, MathewThat is how it works. Try it...I beleive it will help you  a lot

2007-09-07 (first published: )

448 reads

Blogs

T-SQL Tuesday Retrospective #006: What about blob?

By

I am revisiting old T-SQL Tuesday invitations from the very beginning of the project....

Daily Coping 2 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Database Corruption, how to investigate root cause?

By

Introduction: In this article, we will discuss the MS SQL Server database corruption.  So, first, we...

Read the latest Blogs

Forums

vbs failing

By Sailor

This vbscript for Excel that opens a pipe delimited file  is failing srccsvfile =...

SQL Server Load

By narayanamoorthy.a

Hi, The application team is pushing more than 7 lakhs records per day to...

Converting minutes to hh:mm:ss

By DaveBriCam

I'm trying to develop a formula to convert minutes (my raw data) to hh:mm:ss...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

WHILE in R

See possible answers