<div>
what is your issue? are your variable/fields nullable?
</div>


what is your issue? are your variable/fields nullable?

<div>
Hi Eric,<br />
<br />
- what is your issue? <br />
Not check to data yet.<br />
Just want to make sure it is the correct way to do it.<br />
<br />
- are your variable/fields nullable? <br />
How to overcome this ?<br />
<br />
Thank you.
</div>


Hi Eric,

- what is your issue?
Not check to data yet.
Just want to make sure it is the correct way to do it.

- are your variable/fields nullable?
How to overcome this ?

Thank you.

<div>
Hi Eric,<br />
<br />
Thank very much for your help.
</div>


<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I have a SP with filter, if @TENOR = &nbsp;0 then filter data with Tenor 0, else Filter Data with Tenor &gt;&nbsp;0.<br />
<br />
I try below :<br />
<br />
&nbsp;AND H.Tenor =<br />
&nbsp;IIF(@TENOR &lt;&gt;&nbsp;0 AND H.Tenor &gt;&nbsp;0, H.Tenor, 0)<br />
<br />
What's wrong with this ?<br />
<br />
Thank you.
</div>
</div>


Hi All,

I have a SP with filter, if @TENOR =  0 then filter data with Tenor 0, else Filter Data with Tenor > 0.

I try below :

 AND H.Tenor =
 IIF(@TENOR <> 0 AND H.Tenor > 0, H.Tenor, 0)

What's wrong with this ?

Thank you.

Filter Data Tenor

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.