jeudi 16 juillet 2020

Output CheckBox flag if a record exist in SQL

I am doing a left outer join to return everything from left, matching records between two tables and nulls from the right table. then I wrote a case statement to set 1 if the record exist in the right table 0 if it doesn't. (CASE WHEN Invoice.InvoiceID IS NOT NULL THEN 1 ELSE 0 END) AS Invoiced

Can I somehow output a checkbox instead of 0 and 1? checkbox checked if the record exists? in SSMS?




Aucun commentaire:

Enregistrer un commentaire