ALTER procedure [dbo].[spstdinfo] @year_p int as select Catg_type.Catg_type,Program_type.Prog_name ,Year_info.year, COUNT(Std_info.catg_id) as total_students from Std_info inner join Catg_type on Std_info.Catg_id=Catg_type.Catg_id INNER join Program_type on Std_info.Prog_id=Program_type.Prog_id inner join Year_info on Std_info.year_id=Year_info.year_id where @year_p=Year_info.year group by Catg_type,Program_type.Prog_name,Year_info.year
var re = (from stdtable in a.Std_info join catg in a.Catg_type on stdtable.Catg_id equals catg.Catg_id join prog in a.Program_type on stdtable.Prog_id equals prog.Prog_id join yea in a.Year_info on stdtable.year_id equals yea.year_id select new { Std_info = stdtable, Catg_type = catg,Program_type=prog,Year_info=yea });
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)