SQL Insert Query

[Pashers]

Hey all,

I'm using MSSQL, and came up with this query to display the results I want.
select tutorgroup_name, count(borrower_tutorgroup_id)
from WBLS.dbo.Borrower left outer join WBLS.dbo.tutorgroup on
borrower_tutorgroup_id=tutorgroup_id
group by borrower_tutorgroup_id, tutorgroup_name

It shows the number of tutor group names (e.g. 7x, 8x...) and then the number of pupils in the specific group.

How do I modify the select statement so it will update a field called tutorgroup_total for each different tutor group with the count of number of pupils in the specific group.

Hope this makes sense... I have a headache lol

Thanks!

[theboyhope]

You want to run the update and the select in the same statement and still return the recordset? I don't think you can without a stored procedure. Why not just run the update statement after the select.

HTH.