select CUSTOMERLOANID,PROCESSDATE ,sum(CASHOUTAMOUNT) as CASHOUTAMOUNT, sum(CASHINAMOUNT) as CASHINAMOUNT, sum(INTERESTAMOUNTALLOCATED) as INTERESTAMOUNTALLOCATED , sum(PRINCIPALAMOUNTALLOCATED) as PRINCIPALAMOUNTALLOCATED, LOANBALAMOUNT, FROMWHERE, (select count(CASHOUTAMOUNT) from MASTERLOANTRANSITEM where CASHOUTAMOUNT <> 0 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as CASHOUTAMOUNTNUM, (select count(CASHINAMOUNT) from MASTERLOANTRANSITEM where CASHINAMOUNT <> 0 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as CASHINAMOUNTNUM, (select count(INTERESTAMOUNTALLOCATED) from MASTERLOANTRANSITEM where INTERESTAMOUNTALLOCATED <> 0 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as INTERESTAMOUNTALLOCATEDNUM, (select count(PRINCIPALAMOUNTALLOCATED) from MASTERLOANTRANSITEM where PRINCIPALAMOUNTALLOCATED <> 0 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as PRINCIPALAMOUNTALLOCATEDNUM, (select count(CUSTOMERLOANID) from MASTERLOANTRANSITEM where TRANSACTIONTYPE = 10 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as NEWCASHNUM, (select sum(CASHOUTAMOUNT) from MASTERLOANTRANSITEM where TRANSACTIONTYPE = 10 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as NEWCASHMOUNT, (select count(CUSTOMERLOANID) from MASTERLOANTRANSITEM where TRANSACTIONTYPE = 11 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as ADDCASHNUM, (select sum(CASHOUTAMOUNT) from MASTERLOANTRANSITEM where TRANSACTIONTYPE = 11 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as ADDCASHMOUNT, (select count(CUSTOMERLOANID) from MASTERLOANTRANSITEM where TRANSACTIONTYPE = 12 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as RECASHNUM, (select sum(CASHOUTAMOUNT) from MASTERLOANTRANSITEM where TRANSACTIONTYPE = 12 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as RECASHMOUNT, (select count(CUSTOMERLOANID) from MASTERLOANTRANSITEM where TRANSACTIONTYPE = 50 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as ROLLBACKCASHNUM, (select sum(CASHINAMOUNT) from MASTERLOANTRANSITEM where TRANSACTIONTYPE = 50 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as ROLLBACKCASHMOUNT, (select count(CUSTOMERLOANID) from MASTERLOANTRANSITEM where TRANSACTIONTYPE = 21 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as OVERCASHNUM, (select sum(CASHOUTAMOUNT) from MASTERLOANTRANSITEM where TRANSACTIONTYPE = 21 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as OVERCASHMOUNT, (select count(CUSTOMERLOANID) from MASTERLOANTRANSITEM where TRANSACTIONTYPE = 30 and year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516) as COMPROMISNUM, (select PROCESSDATE from MASTERLOANTRANSITEM where TRANSACTIONTYPE = 10 and PROCESSDATE = (select min(PROCESSDATE) from MASTERLOANTRANSITEM where CUSTOMERLOANID = 100000000516) and CUSTOMERLOANID = 100000000516) as NEWCASHDAY, (select max(NEXTREPAYDAYNORMAL) from MASTERLOANTRANSITEM where year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516 ) as NEXTREPAYDAYNORMAL, (select LOANBALAMOUNT from MASTERLOANTRANSITEM where year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516 and TRANSITEMID = (select max(TRANSITEMID) from MASTERLOANTRANSITEM where year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516 ) ) as LOANBALAMOUNT from MASTERLOANTRANSITEM where year(PROCESSDATE)= year('2004-02-01') and month (PROCESSDATE) = month('2004-02-01') and CUSTOMERLOANID = 100000000516 group by CUSTOMERLOANID
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货