SSRS Multi-Select

Regarding:Multi-Select Parameters for Reporting ServicesRegular Columnist : Adriaan Davel Posted: 08/13/2007  Our solution:Create a table function to parse the values into a table.Usage:In a stored procedure called by SSRS, pass the multi-select values into this function to return a table of key/value pairs.ie:select * from fnCSV_Parse (',' , 'ca,de,ny,wa')yeilds:tblID       Keys-----------------1        […]

2007-08-13

645 reads

Blogs

Daily Coping 4 Mar 2021

By

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

Which configuration changes in SQL Server require a restart?

By

SQL Server is a complex beast, with many configuration options that can range from...

Daily Coping 3 Mar 2021

By

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

Read the latest Blogs

Forums

Datacenter Downtime and SQL backups

By stevec883

I was wondering what others are doing in regards to a datacenter outage and...

Installing missed items in SQL Server

By itmasterw 60042

Hi, Someone, prior to me, installed SQL Server 2019. and missed a few things...

Redesign of old Table

By bobski

Hi, I am working on an old database table which stores emails, including From,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers