assassin87 Posted November 18, 2011 Share Posted November 18, 2011 Hi everyone i want to ask something. Now i have six queries from same stored procdure but i want combine that queries just one query. Here my queries GELİRSELECT SUM(REVENUE) FROM SP_FOLTRANS_STATS_DAY(:B1,:D1) DÜZELTMESELECT SUM(REVENUE) FROM SP_FOLTRANS_STATS_DAY (:B1,:D1) WHERE PAYTYPE='DUZELTME' KREDİSELECT SUM(PAYMENT) FROM SP_FOLTRANS_STATS_DAY(:B1,:D1) WHERE PAYTYPE='KREDI' NAKİTSELECT SUM(PAYMENT) FROM SP_FOLTRANS_STATS_DAY(:B1,:D1) WHERE CASHTYPE = 'NAKIT' KREDİ KARTISELECT SUM(PAYMENT) FROM SP_FOLTRANS_STATS_DAY(:B1,:D1) WHERE CASHTYPE = 'MASTER' OR CASHTYPE = 'VISA' İNDİRİMSELECT SUM(PAYMENT) FROM SP_FOLTRANS_STATS_DAY(:B1,:D1) WHERE PAYTYPE = 'INDIRIM' Now i want GELIR,DUZELTME,KREDI,NAKIT,KREDI KARTI AND INDIRIM with just one query. Can you help me, how can i do that ? Link to comment Share on other sites More sharing options...
birbal Posted November 18, 2011 Share Posted November 18, 2011 you can use union if the data type of columns and count of columns in every query matches Link to comment Share on other sites More sharing options...
assassin87 Posted November 18, 2011 Author Share Posted November 18, 2011 Yeah i know union but i want bring datas quicker than union Link to comment Share on other sites More sharing options...
Synook Posted November 20, 2011 Share Posted November 20, 2011 UNION is pretty quick... it should only take time proportional to the number of tables you are unioning. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.