Home Forums SQL Server 2005 T-SQL (SS2K5) Select from stored proc for many records where single record ID being passed in RE: Select from stored proc for many records where single record ID being passed in

  • August 2, 2012 at 10:58 am

    #1521018

    exec [dbo].[utl_OrganizationByAttribute_s] @OrganizationAttributeTypeID = '1, 2' --A type and B type clients

    The parameter can accept any number of ids, you have to pass it as comma seperated!

    In the above example there are two ids 1 & 2

    I have tested this with thousands of ids as a comma seperated and it just works fine.