Use ap database and the stored procedure named: spbalancerange. exec spbalancerange @balancemin = 200, @balancemax = 100 what does the exec above produce in terms of results. in terms of results, this exec returns vendors with a balance between 200 and 100 dollars. it would return nothing, because the minimum and maximum amounts do produce a valid cross-section to return matching data. if the maximum was coded to be $100, then nothing would be returned because there is no error-checking in the stored procedure, and you can't have a minimum of 200 and maximum of 100, thus no companies would fill that criteria if i were to recode this statement with a @balancemax of 100, i would get an error because it is not possible to have a value between a min of 200 and max of 100. there are no vendors with a 'balance' between 100 and 200 dollars.