goldyabk1 (9/8/2012)
Hi to all I have a Query which is fix likeSELECT StudentId,EnrolmentId,SessionId,SchoolId, Name, ClassGroupId, ClassId, ClassName FROM ViewStudentTable WHERE IsBlock = 0 and sessionid=11 and schoolid=1 and classid=2
I am searching student under session 11 schoolid 1 and classid 2
Output is fine
But now People searching student under session 11 and in schoolid=1
I don't want to change query i wants that output should come with the same query
Create a stored procedure that contains the parameters you want to search for as variables.
--Jeff Moden
Change is inevitable... Change for the better is not.