| Author |
Topic |
|
amsad
Starting Member
17 Posts |
 Posted - 2011-02-08 : 01:32:36
|
| count(case when (kcd.type_id_usg in ('10030','10041','10046','10047','10049','10087','10390','10621','10624','10625','20000','20011','20013','20019','20023','20024','20026','40000','40060') or kcd.type_id_usg like '1000[01234567]' or kcd.type_id_usg like '1001[01234789]' or kcd.type_id_usg like '1002[023456789]' or kcd.type_id_usg like '1005[01245679]' or kcd.type_id_usg like '1006[045679]' or kcd.type_id_usg like '1007[0245678]' ) then 1 end) as countVoice, ----------------------------Hi, I need to apply this script in my system, but its limited and need summarize before put into the system.Any suggestion to summarize that...Thank you,Can do. |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-08 : 01:42:58
|
what do you mean by summarize ... come up with the underlaying tables structure, sample data and the required output format ... Along with your existing query .. This will help us to understand the meaning of Summarize and to help you as required  Cheers!MIK |
 |
|
|
amsad
Starting Member
17 Posts |
Posted - 2011-02-08 : 04:02:00
|
| kcd.type_id_usg in ('10030','10041','10046','10047','10049','10087','10390','10621','10624','10625','20000','20011','20013','20019','20023','20024','20026','40000','40060')or kcd.type_id_usg like '1000[01234567]'or kcd.type_id_usg like '1001[01234789]'or kcd.type_id_usg like '1002[023456789]'or kcd.type_id_usg like '1005[01245679]'or kcd.type_id_usg like '1006[045679]'or kcd.type_id_usg like '1007[0245678]' ------------------Sorry for inconvenience caused.But i just to know how above script(the number) can be shortcut and apply in SQL..Can do. |
|
|
|
|
|
|
Summarize script ( need help)