You need to develop a stored procedure strategy that will manipulate temporary result sets to meet the following requirements…

You need to develop a stored procedure strategy that will manipulate temporary result sets
to meet the following requirements: • Stored procedures must receive result sets as
parameters • The strategy must be developed by using the minimum amount of effort The
result sets will contain less than 1,000 rows. What should you use?

A.
a common table expression (CTE)

B.
a view