Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- (SELECT 1 WHERE EXISTS(SELECT TOP 1 1 FROM nn n WHERE n.idNaa=x.idNaa)),
- (CASE
- WHEN EXISTS (SELECT TOP 1 1 FROM nn n WHERE n.idNaa=x.idNaa) THEN 1
- ELSE 2
- END )
- FROM cc x where idClient =3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement