Hi, i have a data type table which i pass from C# with list of int.
i use it in the query :
select * from tbl1 where statudid in (select id from datatypetable)
the questio if the data type table which i pass is empy,
how can i get all value as doing some like
statusid=case when "datatypetable is empty" then statusid else (select id from datatypetable) end