Hi,

The SP only returns one result set, however there are a few statements setting up the parameters for the query ( the do contain select statements, and the parameters are SET into declared variables).