quote:

---

The full syntax of the SELECT statement is complex, but the main clauses can be summarized as:

SELECT select_list

[ INTO new_table_name ]

FROM table_list

[ WHERE search_conditions ]

[ GROUP BY group_by_list ]

[ HAVING search_conditions ]

[ ORDER BY order_list [ ASC | DESC ] ]

---

;with y (weight, high) as
(
select 10, 20 union all select 25,50 --union all select 1,1
)

select sum(weight) as totalweight, sum(high) as totalheight
from   y
HAVING SUM(WEIGHT)=SUM(HIGH)/2

output:
totalweight totalheight
----------- -----------
35          70

IF NOT EXISTS ( 
       SELECT S.CALLID,SQ.QUESTION,SC.CATEGORY,SA.ANSWERDESC,SA.WEIGHT,SA.HIGH
       FROM SURVEY S
       JOIN SURVEY_RESPONSE SR
       ON S.SURVEY_ID=SR.SURVEY_ID
       JOIN SURVEY_QUESTION SQ
       ON SQ.QUESTION_ID=SR.QUESTION_ID
       JOIN SURVEY_CATEGORY SC
       ON SC.CAT_ID=SQ.CAT_ID
       JOIN SURVEY_ANSWER SA
       ON SR.ANSWER_ID=SA.ANSWER_ID
       WHERE (CONVERT(varchar(10), s.Submit_date, 101) = CONVERT(varchar(10), GETDATE()-1, 101))
       GROUP BY S.CALLID,SQ.QUESTION,SC.CATEGORY,SA.ANSWERDESC,SA.WEIGHT,SA.HIGH
       HAVING SUM(WEIGHT) < SUM(HIGH/2)
)
RAISERROR('no records found',16,1)