on 12-12-2016 8:09 PM
Olá Erikson,
Tente assim:
SELECT
TOP 1
'TRUE'
FROM
OCRD T0
INNER JOIN CRD1 T1 ON T0.[CardCode] = T1.[CardCode] AND T1.[AdresType] = 'S'
WHERE
T0.[GroupCode] = '110'
AND T1.[State] <> 'MG'
AND T0.CardCode = $[$4.0.0]
Atenciosamente,
Diego Lother
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Olá, Diego!
Pelos meus testes, deu certo agora.
Muito obrigado!
Abraço!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.