Question

QUESTION 9

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.
		There are no Vendors with a 'Balance' between 100 and 200 dollars.
		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.

Answer 1

Answer)

9) 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 a max of 100.

As the max is 100 and minimum is 200 hence it would throw an error.

Hit like if you find the answer useful. :)
Hope this answer helps. Thanks