Filter resultset by passing a table value parameter

[Tiago]

Hi everyone,

I'm trying to create a test for a stored procedure that returns 2 result sets and Im only interested on the 2nd one.

This SP takes some parameters and one of them is a table value parameter .

Do you have any idea on how can I make it work?

Something like this:

CREATE TYPE countryList AS TABLE(

countryID smallint

)

DECLARE @countryList as countryList ;

insert into @countryList VALUES(1),(2)

EXEC tsqlt.ResultSetFilter 2, 'exec myprocedure @countries = @countryList"

Error : " System.Data.SQLClient.SQLException: Must declare the scalar variable "@countryList" "

Thanks all,

Tiago

[Sebastian Meine]

Tiago,

try putting the declaration and the insert inside of the command that tSQLt.ResultSetFilter is executing.

Thanks,

Sebastian

--
You received this message because you are subscribed to the Google Groups "tSQLt" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tsqlt+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tsqlt/a2d10cb9-22f7-4614-95df-d2d938433041n%40googlegroups.com.

[Tiago]

Spot on.

Thanks a lot Sebastian, that made the trick.

Have a good weekend all,

Tiago