Technical Article

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

684 reads

Blogs

Daily Coping 7 Feb 2023

By

Today’s coping tip is to go to bed in good time and allow yourself...

Tales From The Field Weekly Wrap Up for the Week of 01-31-2023

By

 Hello Dear Reader!  After a weekend with a lot of activities, it was a...

Creating a Flyway Desktop Shadow Database in PostgreSQL

By

In order to generate migrations, we need to configure Flyway to use a shadow...

Read the latest Blogs

Forums

Converting nested Json document to SQL data

By mandavli

I have response from a API that look like { "responseCode": 200, "message": "success",...

Converting nested Json document to SQL data

By mandavli

I have response from a API that look like { "responseCode": 200, "message": "success",...

To Drop or Not to Drop (the temp table question)

By Brandie Tarvin

So here's a thing that I've been told several times over the past few...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers