Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Declaring a variable that takes more than one values

    Send parameter '031-530-9,031-530-10,031-530-2'

    Create a stored procedure to split values by comma

    for example:

    SET @Account_N0 = '031-530-9,031-530-10,031-530-2'

    Select * from account where Account_No in (Select data from dbo.Split(@Account_No,',')

    ----- Split function code is

    CREATE...

Viewing post 1 (of 1 total)