sql server - SQL Group by doesn't show all variables -


I am getting a list from the MSSQL database, I have a system list and content in a database table. I want to get the summaries. But the database is giving me only rows which are not zero. Here is my code 

  system_no AS 'system name', SUM (case when (mat_2 = 'AS') then 'AS' as '2', SUM (case when (Mat_2 = '' SS ') then in the form of' SS ', SM (case when (mat_2 =' CS ') then' CS 'as' CS 'as' creation 'where' 2014-02- Between 03 'and' 2014-02-09 'group' system 'by' welding_det 'unit,' system name ', SUM (in case when (mat_2 =' AS ') then' AS ', SUM (case when (Mat_2 = 'ss') again mat_2_size In the form of 'SS', SM (case when (mat_2 = 'CS') then mat_2_size end) as 'CS' from fabrication_table where between '2014-02-03' and '2014-02-09' The result of this query is below  
  System Name SS CS Assistant Steam Faucet Faucet 6.75 Chemical Dosing Nouvel 10.00 Tap Off Cooling Water Faucet 1.50 193.75 Condenset Nail Nail 32.00 Diminished Water Nail 34.00 Faucet Feedwater Nail Faucet 6.00 Gases (N2, H2, CO2) Zero Null 385.25 GT Air InkTec Anti-icing Shoe Somewhere taps 220.50 Main Steam & amp; By-pass 49.50 Noull 84.00 Seawater intake faucet 27.50 faucets ST drains 37.50 tap 175.50 ST seals steam faucet 2.25 175.00 Total 87.00 75.25 1278.75   
 But my system name list is:  
 potable water service water seawater intake chemical dosing stop cooling water GT interconnection feedwater hrssyver flyer sampling fire fighting GT Lube oil oxygenic vapor extinct water Dedicated water ST lube & amp; Seal Oil Main Steam & amp; Near Scheduled Tribe drain GT Air intake anti spinning condenser Vacuum ST jaws steam condensed plant drainage punched water compressed air GT drainage fuel gas gases (N 2, H2, CO2)  
 Here my question I want to: List all the variables ie query is not a list of fire fighting, but I want to list fire fight like this  
 Fire Fighting Nail nail nail   < P> 
 
 Try to avoid using "lapsing" values ​​by using the lace:  
 , SUM (case AS (as 'AS')   
 Change:  
 , SUM (case when (mat_2 = 'AS')) organized as 'AS' (mat_2_isize, 0) END)

Comments

Post a Comment

Popular posts from this blog

c - Mpirun hangs when mpi send and recieve is put in a loop -

I was trying to use the program to use mifrewan on 4 node clusters. Distributing node 0 data in nodes 1, 2 and 3. In the program, from '90 'to variable values ​​of' dior 'to be calculated. Therefore the node is distributing data and collecting results in an omitted fashion (for different values ​​of var 'dir') when do {*******} Whereas (dir Loop is given, Mippun is hanging, and no output is found. But when I comment on two {*******} (dir The loop output is obtained for the initial value of variable dir dir = -90 ), and that output is correct. The problem occurs when the loop is given. Can anyone help me in solving this problem. #include "mpi.h" int main (int argc, char * argv []) Float dir = -90; Int rank, nanoprakash; MPI_Status status; MPI_Init (& amp; argc, & argv); MPI_Comm_rank (MPI_COMM_WORLD, & amp; Rank); MPI_Comm_size (MPI_COMM_WORLD, & amp; numprocs); If (rank == 0) {/ / data to begin / / (dest = 1; dest ...
Read more

python - Apply coupon to a customer's subscription based on non-stripe related actions on the site -

I can not find anything in the source about using coupons after subscribing to a user's plan. Is it possible to use a coupon to credit a user's membership after initial subscription? If not, what is the best option? Specifically, I want to give a user 100% coupon for that month, when they take 5 [site specific actions]. This is possible, but may not be the best idea. Coupons are currently applied to the stripe, then apply again at the customer level and each client can have a single coupon. So if you are already offering discounts to the coupon, then the customer who is currently in the present will also give up. It also means that if you are using a recently-added multiple subscription capacity, then all of the user's subscription will be ready for the month. Coupons can be set to "Once", only once (as the only name) can be used by any customer, so if this credit can earn more than once, You will have to maintain a 100% discount coupon continuousl...
Read more

java - Unable to get JDBC connection in Spring application to MySQL -

मैंने स्प्रिंग में डीबी कॉन्फ़िगरेशन का पालन किया है: & lt; bean id = "dataSource" Class = "org.apache.commons.dbcp.BasicDataSource" नष्ट-विधि = "बंद" & gt; & Lt; प्रॉपर्टी नाम = "url" मान = "jdbc: dburl" / & gt; & Lt; संपत्ति नाम = "driverClassName" मान = "com.mysql.jdbc.Driver" / & gt; & Lt; संपत्ति नाम = "उपयोगकर्ता नाम" मान = "उपयोगकर्ता नाम" / & gt; & Lt; संपत्ति नाम = "पासवर्ड" मान = "पासवॉर्फ" / & gt; & Lt; प्रॉपर्टी नाम = "हटाए गए हटाए गए" मान = "सही" / & gt; & Lt; गुण नाम = "प्रारंभिक आकार" मान = "3" / & gt; & Lt; संपत्ति नाम = "अधिकतमअक्टिव" मान = "5" / & gt; & Lt; / सेम ​​& gt; डीबी से गुण मूल्यों को लोड करने के लिए अतिरिक्त कॉन्फ़िगरेशन। & lt; bean id = "config1" class = "org.apache.commons.configuration....
Read more