<div>
<div class="content wysiwyg-content">
I am writing a stored proc for an SSRS report. &nbsp;The user wants the report to bring back all the data on the first run and then allow the user to set 4 parameters. &nbsp;I initially created the report to show nothing until the user selected parameters, but they want all data returned and then filter it out. &nbsp;<br />
<br />
I have four parameters &nbsp;@LiveDate datetime = Null, @Status bit = Null,@CarType varchar(30) = NULL,@somethingelse varchar(30) = NULL<br />
<br />
Then I have a select statement. &nbsp;It the WHERE clause that I am confused about. &nbsp;If the parameters are NULL, then I want to return everything &nbsp;and if not then return according to the parameter values.<br />
<br />
Can someone help me with the WHERE clause here. &nbsp;<br />
<br />
Thanks.
</div>
</div>


I am writing a stored proc for an SSRS report.  The user wants the report to bring back all the data on the first run and then allow the user to set 4 parameters.  I initially created the report to show nothing until the user selected parameters, but they want all data returned and then filter it out.  

I have four parameters  @LiveDate datetime = Null, @Status bit = Null,@CarType varchar(30) = NULL,@somethingelse varchar(30) = NULL

Then I have a select statement.  It the WHERE clause that I am confused about.  If the parameters are NULL, then I want to return everything  and if not then return according to the parameter values.

Can someone help me with the WHERE clause here.  

Thanks.

SQL Server Optional Parameters

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.