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