DECLARE @Temp table
	(
		strLastName varchar(50),
		strFirstName varchar(50),
		strReponse char(10),
		strNomObjet nvarchar(200),
		strDescripteurOrdre char(10),
		strNomDescripteur nvarchar(200),
		strObjetOrdre char(10)
	)


INSERT INTO @Temp
	Select te.stdlastn,te.stdfirstn,COALESCE(NULLIF(REPLACE(tr.T3,'*',''),' '),REPLACE(tr.T2,'*','')),tob.Nom,tob.Affichage,td.Nom,td.Affichage
	from	Bulletin.dbo.tblEleves as te
			INNER JOIN Bulletin.dbo.tblBulletin as tb ON te.stdnumber=tb.NoEtud
			INNER JOIN Bulletin.dbo.tblNomBull as tnb ON tb.NoBull=tnb.ID
			INNER JOIN Bulletin.dbo.tblSection as ts ON ts.ID_Bull = tnb.ID
			INNER JOIN Bulletin.dbo.tblObjet	as tob ON tob.ID_Sec = ts.ID	
			INNER JOIN Bulletin.dbo.tblDescripteur as td ON td.ID_Obj = tob.ID
			INNER JOIN Bulletin.dbo.tblReponse as tr ON tr.ID = tb.ID 
	where	intActif = 1 and 
			tb.NoBull not like '%EdPhy%' 
			and tnb.Nom not like '%EdPhy%' 
			and tnb.Date = '2006-2007'
			and te.STDGRADeID = 3
			and te.schoolid = '1202'
			and ts.Nom = 'MATHÉMATIQUES'
			and tr.[Desc] = td.ID
			and tr.T2 <> 'NULL'
			and tr.T3 <> 'NULL' 
			and (tr.T2 <> '' OR tr.T3 <> '')
	ORDER BY tob.Affichage,td.Affichage

	
	SELECT t1.strNomObjet,t1.strNomDescripteur,t1.strReponse,
	t1.ReponseCount * 100.0/t2.PersonCount AS Percentage
	FROM
	(
	SELECT strNomObjet,strNomDescripteur,strReponse,count(*) AS ReponseCount FROM @Temp
	GROUP BY strNomObjet,strNomDescripteur,strReponse)t1
	INNER JOIN (SELECT strNomObjet,strNomDescripteur,count(*) AS PersonCount FROM @Temp
	GROUP BY strNomObjet,strNomDescripteur)t2
	ON t2.strNomObjet=t1.strNomObjet
	AND t2.strNomDescripteur=t1.strNomDescripteur

quote:

---

Originally posted by lucsky8

WOW thanks man!! thats exacly what i need!
Tks again you made my day!

---