SQL Multiple Calculations In One SP

Hi,

I think that I want to want to build a temporary table in a stored procedure that handles multiple calculations.

I'll try and explain and hopefully you can tell me what i want

First i want to populate a list of all dealerstaff.


Code:

Select * From tblDealerstaff


I Then want to calculate the percentage tasks completed. So i find the number of available awards.


Code:

SELECT TOP (100) PERCENT COUNT(NoPerStaff) AS NoAwardsAvailable
FROM dbo.tblIndivAwards

Then i can find the number awards recieved per person.


Code:

SELECT TOP (100) PERCENT COUNT(dbo.tblIndivAwarded.AwardID) AS AwardCount
FROM dbo.tblIndivAwarded INNER JOIN dbo.tblIndivAwards ON dbo.tblIndivAwarded.IndivAwardID = dbo.tblIndivAwards.IndivAwardID
WHERE (dbo.tblIndivAwarded.staffID = @StaffID)

Trying to get my recordset to look like this >>

Fname + Lname + ((iNoAwarded / iNoAvailableAwards) * 100)

I want to know if it's possible to piece all of this calculation into a single stored procedure. I need to do this sort of thing all the time, as i display overviews of the projects i run to the senior managers.

I always do the maths in the ASP, and consequently i can't sort on the calulated totals.

Is this possible, or am i asking too much ?

Thanks in advance, as any help will be greatly recieved.

Regards,

Chris Brown