samedi 23 juillet 2016

Case into union all select 0

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