How to use condition for row invisible and visible

Question

SELECT uniquiID, CountryFlag, EventImage ,CONVERT(varchar(50), StartDate) as StartDate ,CONVERT(varchar(50), EndDate) as EndDate ,EventName ,Description ,CountryCode ,Remark ,Flag FROM TradefairData this my table- and my flag column value is - Null 0 1 Null 0 1 Then i Want to Know how to Use case when flag=1 then 3rd and 6th row invisible when flag=0 then all row visible else all row visible please help me uniquiID is my uniqueId Column

Piyush Pansuriya · Answer

Hello, Set Flag value in declared parameter DECLARE @Flag INT SET @Flag=0 SELECT uniquiID, CountryFlag, EventImage ,CONVERT(varchar(50), StartDate) as StartDate ,CONVERT(varchar(50), EndDate) as EndDate ,EventName ,Description ,CountryCode ,Remark ,Flag FROM TradefairData WHERE ISNULL(Flag,0)= CASE WHEN ISNULL(@Flag,0)=0 THEN ISNULL(Flag,0) ELSE ISNULL(@Flag,0) END

Dharmraj Thakur · Answer

Please avoid null values of that column by ISNULL() after that you will only 2 values possible 0 and 1 ,Remark ,ISNULL(Flag,0) FROM TradefairData

Manish Kumar · Answer

First of all ,what you have tried so far and how you are identifying 3rd or 6th row. Is it based on primary key?

Hariharan Krishnamoorthi · Answer

SELECT uniquiID, CountryFlag, EventImage ,CONVERT(varchar(50), StartDate) as StartDate ,CONVERT(varchar(50), EndDate) as EndDate ,EventName ,Description ,CountryCode ,Remark ,Flag FROM TradefairData WHERE Flag 1

Manish Kumar · Answer

Ye Dharmraj is correct. Null will not get filter out in case condition . Try below logic for your query. declare @id int set @id=0 declare @tbl table ( id int ,flag int) insert into @tbl select 1,null union all select 2,0 union all select 3,1 union all select 4,null union all select 5,0 union all select 6,1 select * from @tbl select id,case when flag=100 then null else flag end as flag from ( select id,isnull(flag,100) as flag from @tbl ) a where flag=case when @id=1 then 1 else case when @id=0 and (flag=0 or flag=100) then flag end end Thanks

Mukesh · Answer

3rd and 6th row of value is 1 where in flag column