KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a CTE query filtering a table Student Student ( StudentId PK, FirstName , LastName, GenderId, ExperienceId, NationalityId, CityId ) Based on a lot filters (multiple cities, gender, multiple experiences (1, 2, 3), multiple nationalites), I create a CTE by using dynamic sql and joining the student table with a user defined tables ( CityTable, NationalityTable,... ) After that I have to retrieve the count of student by each filter like CityId City Count NationalityId Nationality Count Same thing the other filter. Can I do something like ;With CTE( Select FROM Student Inner JOIN ... INNER JOIN ....) SELECT CityId,City,Count(studentId) FROm CTE GROUP BY CityId,City SELECT GenderId,Gender,Count FROM CTE GROUP BY GenderId,Gender I want to something like what LinkedIn is doing with search(people search,job search) http://www.linkedin.com/search/fpsearch?type=people&keywords=sales+manager&pplSearchOrigin=GLHD&pageKey=member-home It's so fast and do the same thing.
Tags (comma-separated)
Save Edits
Cancel