none
Handle multiple input values in one SP Parameter

    Question

  • Hi ,

    I'm using that SP

    ALTER Procedure [dbo].[SP_GSK_Value]
    (

    @PSKUCode Varchar(50)=null)

    RIGHT NOW , @PSKUCode can accept one value based on this ..

    exec [SP_GSK_Value] 'AB001'

    FROM [GSKCH].[dbo].[SKUWISE] A(NOLOCK)
       WHERE [PSKUCode]=ISNULL(@PSKUCode,PSKUCode)

    But, I want that It can accept multiple dynamic values from Table directly

    For example

    exec [SP_GSK_Value] 'AB001,BC002,NF003'

    Tuesday, April 08, 2014 5:11 AM

Answers

All replies