You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Reporting Services (SSRS) report for the company.
A parameter named Kind is contained in your developed report and you use it to filter a list of Sales.
Besides, the list uses a dataset, which includes the queries of
SELECT p.SalesID, p.Place, p.ListName, FROM SalesAmount.Sales AS p
WHERE p.Kind = @Kind.
To meet the business requirements, the report parameter is modified to allow multiple values.
Now you are asked to modify the report to help search for multiple Kind values and minimize the development effort.
What action should be performed to achieve the goal above?
A.
The query should be modified by using the IN operator instead of the = operator
B.
The query should be implemented in a stored procedure that uses dynamic SQL for execution
C.
The query should be modified in a table-valued user-defined function.
D.
The query should be implemented in a view
E.
The query should be implemented in a table-valued user-defined function.