Description:
The "View All Responses" in Questionnaire Report fails to retrieve the responses of type text, bool, date and single from the MS-SQL database.
This is mainly due to the issue in using fields of type text in GROUP BY clause. The following methods in questiontypes/questiontypes.class.php are affected by this bug:
1. get_response_text_results()
2. get_response_date_results()
3. get_response_single_results()
4. get_response_rank_results

Steps to reproduce:
1. Create a questionnaire with question type "text box", "drop box" and "date"
2. Login as student and attempt the questionnaire
3. Login again as administrator/teacher and click on "All Responses" tab in the Questionnaire.

Expected Result:
All responses should list all the questions with their responses

Actual Result:
The responses of "text box", "date", and "drop box type " are not displayed.