AUTHOR: Stephania Tapela
DATE POSTED: May 30, 2016
Article information
Article relates to
Telerik Reporting
Created by
Stef, Telerik
Last modified
January 19th, 2017
Last modified by
SELECT
*
from
HumanResources.Department
WHERE
(COALESCE(@SelectedValues,Null)
IS
NULL
)
OR
DepartmentID
IN
(@SelectedValues)
USE AdventureWorks
GO
SET
ANSI_NULLS
ON
QUOTED_IDENTIFIER
-- FUNCTION TO SPLIT STRINGS.
CREATE
FUNCTION
splitstring
( @stringToSplit
VARCHAR
(
MAX
) )
RETURNS
@returnList
TABLE
([
Name
] [nvarchar] (500))
AS
BEGIN
DECLARE
@
name
NVARCHAR(255)
@pos
INT
WHILE CHARINDEX(
','
, @stringToSplit) > 0
@pos = CHARINDEX(
, @stringToSplit)
=
SUBSTRING
(@stringToSplit, 1, @pos-1)
INSERT
INTO
@stringToSplit =
(@stringToSplit, @pos+1, LEN(@stringToSplit)-@pos)
END
@stringToSplit
RETURN
-- STORED PROCEDURE.
PROCEDURE
UseMultiValues
@SelectedValues nvarchar(150) =
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
NOCOUNT
;
select
where
(@SelectedValues
[
]
dbo.splitstring(@SelectedValues))
= IIf(Parameters.SelectedValues.Value Is Null,
Null,
Join(',',Parameters.SelectedValues.Value))
Resources Buy Try