pb procedure stockée SQLServer

Version imprimable

ma proc Stock est la suivante
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 CREATE PROCEDURE dbo.PS_ListeIntermediaires @DR varchar(30), @NumLot varchar(10) AS BEGIN SELECT DISTINCT AG_NUM_AG_MMA FROM MT_AGENTS WHERE AG_NUM_AG_HELVETIA = (SELECT DISTINCT CDG_NUM_AG_HELVETIA FROM MT_CONTRATSDG WHERE CDG_DR_CF =@DR AND CDG_NUM_LOT = @NumLot) ORDER BY AG_NUM_AG_MMA END GO
mais ça ne marche pas parce-que le 2eme select me renvoie plusieurs elements, comment pourrai-je recuperer tous les elements associés a la 2eme requette?

c'est koi l'erreur de syntaxe ici ???

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
AS
BEGIN
 
 
SELECT COUNT(CDG_NUM_AG_HELVETIA)
FROM  MT_CONTRATSDG
 
WHERE CDG_DR_CF =@DR
	 AND CDG_NUM_LOT = @NumLot
 
fot (j==0,j<=COUNT(CDG_NUM_AG_HELVETIA),j++)
 
SELECT DISTINCT AG_NUM_AG_MMA
FROM MT_AGENTS
WHERE AG_NUM_AG_HELVETIA =i_CDG_NUM_AG_HELVETIA
 
 
ORDER BY AG_NUM_AG_MMA
 
END
GO

et si tu fais ca :

Code:

1
2
3
4
5
6
7
8
9
10
 
SELECT DISTINCT AG_NUM_AG_MMA
FROM MT_AGENTS
WHERE AG_NUM_AG_HELVETIA IN (SELECT DISTINCT CDG_NUM_AG_HELVETIA
FROM  MT_CONTRATSDG
 
WHERE CDG_DR_CF =@DR
	 AND CDG_NUM_LOT = @NumLot)
 
ORDER BY AG_NUM_AG_MMA