select true if exists on another table or false sqlserver
snippet in sql

select true if exists on another table or false sqlserver

user7967

  select A.name, 
       CASE WHEN B.name IS NOT NULL
       THEN 1
       ELSE 0
       END

    from table1 A
    left join table2 B
    on A.name = B.name