Your application contains a stored procedure for each country. Each stored procedure accepts an
employee identification number through the @EmplD parameter. You need to build a single
process for each employee that will execute the appropriate stored procedure based on the country
of residence. Which approach should you use?

A.
A SELECT statement that includes CASE

B.
Cursor

C.
BULK INSERT

D.
View

E.
A user-defined function