Home Forums SQL Server 2008 SQL Server 2008 - General How to create a procedure which takes multi value parameter -Urgent Help Needed RE: How to create a procedure which takes multi value parameter -Urgent Help Needed

  • there may be two ways of doing this:

    1) using Table Valued Parameters

    2) By passing the filter that will be used to determine the result set from TableA and perform an innser join using that, e.g.

    CREATE PROCEDURE MyProcedure

    @p_name1 DataType, @p_name2 DataType

    FROM TableB

    INNER JOIN Table A ON TableA.Column = TableB.Column AND TableA.OtherColumn = @p_name1

    WHERE TableB.AnotherColumn = @p_name2

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”