Create Procedure Match_Detail
@Classification int,
@Mc_id int,
@Output varchar(30) OUTPUT
AS
BEGIN
--if C_Name=@Classification
--begin
select c.C_Name AS 'Classification',s.S_name,f.F_Date AS 'Match
Date',f.F_time AS 'Match Time',m.M_TossWonBy AS 'Toss Won By'
from Classification c join Series s
on c.C_id=s.S_id join Fixtures f
on c.C_id=f.F_id join Match m
on s.S_id=m.M_id
where c.C_id = @classification
select @Output=MC_Reason
From Match_closure
where Mc_id=@Mc_id
--end
--else print 'nothing'
END