Advertisement
Advertisement
| 05.21.2008 at 04:11AM PDT, ID: 23420295 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: |
SELECT sum(CASE when S.Compl between 1 and 20 AND S.risk = 1 then S.risk else 0 end) AS AMTGain, -- it's good perfect
sum(CASE when S.Compl between 1 and 20 AND S.risk = 0 then S.risk else 0 end) AS AMTLoser,
FROM tbl_Transact AS S with (nolock)
join tbl_Custs as u with (nolock) on s.idutente = u.idutente
WHERE (u.testuser = 0) -- no test user
AND (CONVERT(CHAR(8), S.Date, 112) BETWEEN '20080520' AND '20080520')
|