Technical Article

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

You rated this post out of 5. Change rating

2007-09-07 (first published: )

466 reads

Blogs

Jan Vaněk: Na podpis smlouvy jsem přišel v kiltu a teď vedu SWAT tým

By

The post Jan Vaněk: Na podpis smlouvy jsem přišel v kiltu a teď vedu...

MVP No more, But It’s OK

By

Embracing Limitations: Finding Strength and Purpose in Hard Times For four years, I was...

A New Word: Fitching

By

fitching – v. intr. compulsively turning away from works of art you find frustratingly,...

Read the latest Blogs

Forums

SQL Server Admin Role Alert Script

By SQLShark

Comments posted to this topic are about the item SQL Server Admin Role Alert...

Sessions and CPU Threads

By Alejandro Santana

Hello everyone, I've got a question when it comes to best practices about application...

Sum Nested Join Help

By beantownace

Hello all, I have a query where I am trying to do a left...

Visit the forum

Question of the Day

A Valid Type?

What happens when I run this code in SQL Server 2019?

DECLARE @variable CURSOR;

See possible answers