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

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(Flag0) 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

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(Flag0)= CASE WHEN ISNULL(@Flag0)=0 THEN ISNULL(Flag0) ELSE ISNULL(@Flag0) END

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 1null union all select 20 union all select 31 union all select 4null union all select 50 union all select 61 select * from @tbl select idcase when flag=100 then null else flag end as flag from ( select idisnull(flag100) 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

mukesh55965 . · Answer

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