Home Forums Reporting Services Reporting Services ? Must declare scalar variable ? on a multi slect RE: ? Must declare scalar variable ? on a multi slect

  • May 8, 2015 at 4:02 pm

    #1796755

    jbalbo (5/8/2015)

    Hi

    I'm not sure what I am doing wrong I have a multi select parameter which work if I only choose one value

    but I get Must declare the scalar variable "@None" when I choose more than one

    here is a snipet of my code

    ALTER PROCEDURE [dbo].[CASELOAD]

    @Program NVARCHAR #MAX#

    ,@None VARCHAR #8000#

    As

    Select....

    where ...

    --AND

    -- Table.Name

    -- IN #@None#

    Thanks

    Joe

    I am assuming you are passing in a comma delimited string in the @NONE parameter of your stored procedure. You need to do something like this:

    ...

    where ...

    --AND

    -- Table.Name IN (select Item from dbo.DelimitedSplit8K(@None,','))

    You can find the dbo.DelimitedSplit8K function under resources with this article: http://www.sqlservercentral.com/articles/Tally+Table/72993/.