How To put Ratios in sqlquery

See more:

SQL-Server-2005

SQL-Server

Dear Friends,

Here i want to Find Ratios in sqlquery.In my Project i want to Implement Ratios of Students and staff in Perticular District

So iam sucess up to this:
My OutPut:

txtDistName      intStaff   intStudents
Zanzibar Urban   212130     168

So now i wat to Display the ratio of intsatff and intStudents

txtDistName      intStaffStudents
Zanzibar Urban   212130/100:168/100

So i want the rations of that Coloumns

Iam Sending my sample Query:

SELECT        ntblDistrict_1.txtDistrictName, SUM(tblSummaryStudents.intMale + tblSummaryStudents.intFemale) AS intStudents, 
                         SUM(tblSummaryOthers.intTeachersMale + tblSummaryOthers.intTeachersFemale) AS intStaff
FROM            ntblDistrict AS ntblDistrict_1 INNER JOIN
                         ntblPrimarySchoolList ON ntblDistrict_1.intDistrictID = ntblPrimarySchoolList.intDistrictID INNER JOIN
                         tblSchool ON ntblPrimarySchoolList.intPrimaryListID = tblSchool.intPrimaryListID INNER JOIN
                         tblSummaryOthers ON tblSchool.intSchoolID = tblSummaryOthers.intSchoolID INNER JOIN
                         tblSummaryStudents ON tblSchool.intSchoolID = tblSummaryStudents.intSchoolID
WHERE        (ntblDistrict_1.intDistrictID IN
                             (SELECT        intDistrictID
                               FROM            ntblDistrict AS ntblDistrict
                               WHERE        (intDistrictID = 9)))
GROUP BY ntblDistrict_1.txtDistrictName

Regards,

Anilkumar.D