Hi My friends,
I have the following tables:
Applicants : Id, FullName, Gender , Email, SectorId, CreatedDate
Sectors : Id, Title, IndustryId
Education: Id, Title, ApplicantId,DegreeId
EducationDegree: Id, Title, EducationId
Experience: Id, Title, ApplicantId, CompanyName, DateTo, DateFrom
Q. How can I create a stored procedure to search in applicants (I want to search by sector, Industry, Gender, Degree, years of Experience) ?