I want to create a two cases first one i want union select 0 and second if its not 0 UNION ALL SELECT cast(0 as varchar(50))
I need something like that
UNION ALL SELECT case when union select >0 then cast(0 as varchar(50)) else union select 0 end from inventory
Aucun commentaire:
Enregistrer un commentaire