sql server - sql I don't want to lose null values when I'm using group by -

-

I am trying to figure out which merch has traveled a poi out of its way . To do this I need to find void values ​​from vp.poiid, but when I lose zero value on that column, I create the group. 

 . . (As the date, select me.MerchName vp.routedate, mercid as me.id, as done ov.poiid, planned, vp.poiid as the case when ov.poiid re-calculate (Ov.poiid) is notDone the end, the case is when vp.poyid void again counting (vp.poiid) end outOfRoute asb_visitplan joining in full from the vice president on the OutVisitData ov (vp.poiid = ov.poiid and ov. Commitdate = vp.routedate and vp.merchid = ov.merchid) include atb_merchs me on (vp.merchid = me.id) where my.id = 1 group vp.rateet, m. mercked, iiid , Ow. Poiid, vp.poid) A. . .

When I run this program, I get this view: 

  Date Name ID planned Not Out Out 2013-11-06 00: 00: 00.000 Seven Fungus 1 30 30 0 Newell 2013-11-06 00: 00: 00.000 Seven Fungus 1 34 34 Faucet 2013-11-06 00: 00: 00.000 Seven Fungus 1 48 48 Faucet 2013-11-06 00 : 00: 00.000 Seven Kavak 1 54 54 0 Zero 2013-11-06 00: 00: 00.000 Seven Kavak 1 Zero 1235 1235 Zero 2013-11-06 00: 00: 00.000 Seven Kavak 1 Zero 1236 1236 Zero 2013-11-07 00: 00: 00.000 Seven Kavak 1 30 30 0 Zero 2013-11-07 00: 00: 00.000 Seven Kavak 1 49 49 0 Zero

You get all the results in outOfRoute values ​​in this result (But it is not really) as a matter of fact. Is there a way to see actual results in this table? And I need to group these columns, this is a subquiry and I count the final results in the planned column actually there are zero values ​​but I can not even see them.

PS: I am using SQL Server

I think that I forgot for the first time you know, do not want to count the records who have nulls for those guys? 

  ov.poiid ov.poiid is zero) from the COUNT (selection), VP notDone, COUNT (ou select from VP as POIID IS NULL) says its current statement "these records Display the count when the grouped field is zero, "which never appears. 
 
 
 
 You will need to redefine the joining of those selections; I went for brevity for the moment. 
 
 (I got the answer again, the better answer.)

Comments

Post a Comment

Popular posts from this blog

winforms - C# Form - Property Change -

-
I have a form that has a property named car A class with many properties. The Properties is being displayed on the current car on the basis of some user actions that are being displayed. So I have to know whether the property has been allocated or set to zero. I'm aware of INotifyPropertyChanged , but in my case I'm not sure that since this change I have changed my car properties car do not want to monitor the property. Any idea how to accomplish this? In advance thank you If you have created a true asset in your class then You should be a great and setter, you can add the code directly to the form property in order to take action on the basis of "form": Public partial category Form 1: form {public form 1 () {InitializeComponent (); } // define car square public class car {public string name = string. Empty; } // private car to keep the value of the current car private variable _car = null; // Property of public form which you can ru...
Read more

javascript - amcharts makechart not working -

-
I am trying to create an amiratars serial chart on my Durandal single page application. This chart was working fine on Chrome browser but it is not working on IE. Can you please help me in this regard. Error while using Amcharts. The Macchart () method does not support the object in this object in IE.
Read more

java - Algorithm negotiation fail SSH in Jenkins -

-
I am trying to do SSH on the local server from Jenkins, but the following error has been thrown: [SSH] Exception: Algorithm negotiation fail com.jcraft.jsch.JSchException: algorithm talk com.jcraft.jsch.Session.receive_kexinit (Session.javaatar20) at com.jcraft.jsch.Session.connect (Sesson at com.jcraft.jsch.Session.connect (Session.java:150) at org.jvnet.hudson.plugins.SSHSite.createSession (SSHSite.java:141) on failed failed org.jvnet.hudson.plugins. java: 286) .SSHS on org.jvnet.hudson.plugins.SSHBuildWrapper.executePreBuildScript (SSHBuildWrapper.java:75) on Org.jvnet.hudson.plugins.SSHBuildWrapper.setUp (SSHBuildWrapper.java59) ite.executeCommand (SSHSite.java151) on hudson.model.Build $ BuildExecution.doRun hudson.model.AbstractBuild $ AbstractBuildExecution.run (AbstractBuild.java:533) to (Build.java:154) hudson.model.Run.execute ( Run.java:1754) in ended .model.FreeStyleBuild.run (FreeStyl hudson.model.ResourceController.execute (ResourceController.java:89) on hudson.mod...
Read more