Query problem merge 2 query into one.

Posted by Rajesh_Kumar under Sql Server on 7/1/2015 | Points: 10 | Views : 382 | Status : [Member] [MVP] | Replies : 1
Hi All,
I have below queries like:-

select * from notification_email where is_send_email_flag = 'N';
select * from notification_email;

first query returns data which have is_send_email_flag = 'N'
and second query returns all records irrespective of is_send_email_flag in('N','Y')
So,for that i have created two stored procedures.
But i want to merge these queries into one and pass @is_send_email_flag variable to get all records or only is_send_email_flag = 'N'.
So how do i achieve that one with one query.I have written somewhere with Coalesce function which returns all records if no value is passed in a query.
But i forgot. Can anyone help me to solve my problem.Because unnecessary i am writing 2 queries.

Rejesh Kumar


Posted by: Bandi on: 7/1/2015 [Member] [MVP] Platinum | Points: 25

DECLARE  @is_send_email_flag CHAR(1) = 'N' -- Pass N or NULL

select * from notification_email
where (is_send_email_flag = @is_send_email_flag or
@is_send_email_flag IS NULL

It returns all records if you pass NULL for @is_send_email_flag variable; if you pass 'N' for @is_send_email_flag variable, it returns the records which have is_send_email_flag = 'N' in the table

Mark This Response as Answer

Rajesh_Kumar, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response