Asked By Divya Ajesh
04-Feb-12 02:13 AM

Hi,
I have 2 Select query in stored a stored procedure. i want to combine 2 select query results because i want to display the
combined result in a grid view.
My Stored procedure is given below
ALTER PROCEDURE [dbo].[Sp_Exam_Student_List]
@Sp_classcreationid int,
@Sp_Sectionid int,
@Sp_Exam_id int
--@Sp_Class nvarchar(50),
--@Sp_Section nvarchar(50)
AS
BEGIN
SELECT StudentPersonalInformation.studentregno ,StudentPersonalInformation.candidatename,
StudentPresentEducationInformation.class,StudentPresentEducationInformation.section,
StudentPresentEducationInformation.rollno
from StudentPersonalInformation full join
StudentPresentEducationInformation on
StudentPersonalInformation.studentregno = StudentPresentEducationInformation.studentregno
where classcreationid=@Sp_classcreationid and classsectioncreationid = @Sp_Sectionid and
StudentPersonalInformation.studentregno = StudentPresentEducationInformation.studentregno
order by StudentPresentEducationInformation.rollno ASC
---------------------------------------------------------------------------------
Above one is the First select query
---------------------------------------------------------------------------------
Select exam_id,CEI.min_mark,CEI.max_mark from ClassExam_Information CEI where CEI.exam_id = @Sp_Exam_id
END