Technical Article

Returning a Comma Delimited string

One of the small quirks of SQL is that it can add each row to a variable.In the most common case, this is used to generate a comma delimited list.The script shows how to do this wiht a scalar function, so that multiple rows are returned.The script shows calculating the column sum the hard way […]

2007-03-26 (first published: )

570 reads

Blogs

Daily Coping 12 Aug 2022

By

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

My Toolbox - Greenshot

By

Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...

Daily Coping 11 Aug 2022

By

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

Read the latest Blogs

Forums

SSMS: Remove highlight in current cell of grid output

By Aaron N. Cutshall

I'm trying to capture some screen shots of query results for documentation. I'd like...

Need to rollup some rows to columns

By sqlfriend

Hello, thanks in advance for any help. I have a query like this: select...

A way to make this dynamic SQL

By mw_sql_developer

  Team: Is there an easy way to squeez this sql statement to a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers