Hi,
I have a situation in my SP.... 2 where conditions thre... one is mandatory and other is optional.
Please let me know if optional value is not null it should also be taken to condition ...if not it must take one mandatory value for condition.
Thanks in advance
Manish Kumar ChoudharyPosted Dec 11, 2014, 6:11 AM
use OR operator between mandatory and optional condition in where condition