|
Somnath_lnt
Starting Member
India
1 Posts |
 Posted - 09/26/2012 : 00:19:33
|
SELECT tblplsrptextract1.strSpyIDocType AS SPYDOCTYPE
, SUM(CASE WHEN tblplsrptextract1.strusriproduct = 'APP-NEW' THEN 1 ELSE 0 END) AS APPNEW
, SUM(CASE WHEN tblplsrptextract1.strusriproduct = 'APP-RENEWAL' THEN 1 ELSE 0 END) as APPRENEWAL
FROM tblplsrptextract1
Now we want only
tblplsrptextract1.strusriproduct = 'APP-RENEWAL' to be present as field so that we can take that field in crystal report and take sum there, not in procedure..
Can someone help me on this???
I want to explore |
Edited by - Somnath_lnt on 09/26/2012 00:24:07
|
|
procedure related
