Fórum Erro de Sintaxe #33218
23/08/2005
0
DECLARE @QT VARCHAR(1) , @RA VARCHAR(10)
SELECT @RA = EALUBOLSA.MATALUNO, @QT = COUNT(*),
CASE
WHEN @QT = ´2´ THEN ´S´
WHEN @QT = ´1´ THEN ´N´
END
FROM EALUBOLSA
WHERE EALUBOLSA.PERLETIVO IN (´2005´,´2005/2´)
AND EALUBOLSA.CODSERVICO = ´3´
GROUP BY EALUBOLSA.MATALUNO
ORDER BY EALUBOLSA.MATALUNO
Erro
------
Server: Msg 141, Level 15, State 1, Line 12
A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.
-------
Desde já grato!
Jbb
Curtir tópico
+ 0Posts
23/08/2005
Rjun
SELECT
EALUBOLSA.MATALUNO,
COUNT(*) AS TOTALALUNO,
CASE
WHEN COUNT(*) = ´2´ THEN ´S´
WHEN COUNT(*) = ´1´ THEN ´N´
END
FROM
EALUBOLSA
WHERE
EALUBOLSA.PERLETIVO IN (´2005´,´2005/2´) AND
EALUBOLSA.CODSERVICO = ´3´
GROUP BY
EALUBOLSA.MATALUNO
ORDER BY
EALUBOLSA.MATALUNO
Gostei + 0
23/08/2005
Jbb
Rs.
Gostei + 0
23/08/2005
Rjun
Gostei + 0
23/08/2005
Jbb
Já resolvi utilizando table temporária....
Abs.
Gostei + 0
Clique aqui para fazer login e interagir na Comunidade :)