How to use condition for row invisible and visible

Mukesh

9y1.2k

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

Null

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hariharan Krishnamoorthi9y ago
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 Pansuriya9y ago
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
Manish Kumar9y ago
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
Dharmraj Thakur9y ago
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
Mukesh9y ago
3rd and 6th row of value is 1 where in flag column
Manish Kumar9y ago
First of all ,what you have tried so far and how you are identifying 3rd or 6th row.
Is it based on primary key?