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.