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

679 reads

Blogs

What’s next: Job search burnout

By

I was given 4.5 months notice this past June and was fortunate to find...

InvalidAbfsRestOperationException in Azure Synapse notebook

By

Problem The first issue that developers in my team noticed was when they tried...

What do we want to achieve by encrypting our data?

By

On the face of it, this is a very obvious question with a very...

Read the latest Blogs

Forums

Multitenant architecture

By mto89

Hi all, i have to refactor an existing database multi-tenant. All tables should be...

log shipping restore from primary server backup directory

By sqlfriend

To understand the concept of transaction log shipping, in below case, will it work:...

Optimization for Single Table with Thousands of Concurrent Updates

By keith.west-982594

I have a table with 5 million records and each record requires a "Value"...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers