SELECT * FROM 
(
SELECT TOP 1000 *
  FROM Evaluations_scores_all
) a

SELECT * FROM 
(
SELECT DISTINCT
  Evaluations_scores_all.evaluatee_name,
  Convert(varchar(20),Evaluations_scores_all.call_id),
  Evaluations_scores_all.eval_local_time_the_datetime,
  Form_components.form_component_title,
  Evaluations_scores_all.evaluator_name,
  Evaluations_scores_all.form_title,
  Evals_on_form_component.score,
  Evaluations_scores_all.sess_local_time_the_datetime,
  Evaluations_scores_all.sess_duration,
  Evaluations_scores_all.group_name,
  Evaluations_scores_all.eval_local_datetime,
  Evaluations_scores_all.form_revision_id
FROM
  Form_components INNER JOIN Evals_on_form_component ON (Evals_on_form_component.form_component_key=Form_components.form_component_key)
   INNER JOIN ( 
  select * from Evaluations_scores_all where self_bo_title='user'
  )  Evaluations_scores_all ON (Evaluations_scores_all.eval_key=Evals_on_form_component.eval_key)
  
WHERE
  (
   ( Evaluations_scores_all.eval_local_time_the_datetime  
BETWEEN  '03/26/2015 00:0:0' 
AND           '04/24/2015 00:0:0'   )
   AND
    Evaluations_scores_all.group_name  IN ('H6')  
  )
) a