Advertisement
krot

sql server if EXISTS

Mar 29th, 2018
242
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.22 KB | None | 0 0
  1. select
  2.  (SELECT 1 WHERE EXISTS(SELECT TOP 1 1 FROM nn n WHERE n.idNaa=x.idNaa)),
  3.  (CASE
  4.          WHEN EXISTS (SELECT TOP 1 1 FROM nn n WHERE n.idNaa=x.idNaa) THEN 1
  5.          ELSE 2
  6.        END )
  7. FROM cc x where idClient =3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement