How to get the result-set from MS-SQL compute clause.

[vinitha]

Hi,

i have a query(MS-SQL) with union operator and a compute clause. i can get the result set of the union operator , but the comput clause result is not fetched. how do u get the result of the computed value. the query is

---

select COUNT(APPLICATIONID) as T1 MMKN_GeneralApplication_Status where SM=1 and applicationid
not in( select b.applicationid from mmkn_agenda_applications a, mmkn_generalapplications b where
a.referenceno=b.referenceno)

union select COUNT(APPLICATIONID) AS T1 KN_GeneralApplication_Status1 where SM=1 AND applicationid

not in( select b.applicationid from mmkn_agenda_applications a, mmkn_generalapplications b where

a.referenceno=b.referenceno) GROUP BY APPLICATIONID COMPUTE SUM(COUNT(ApplicationID))

the result is :

T1

1
3

sum

4

(3 row(s) affected)

the num of fields(odbc) returned is only 1 i.e T1 and the sum column value is not available.

Please help.