Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ruckus09
Starting Member
1 Post |
 Posted - 2013-10-24 : 12:23:54
|
| So I am working on my database. I've connected it to Excel and atfirst I thought it was working but for some reason it is not displaying all of the records that I expect it to display. It is supposed to display all orders that are shipped on mondays tuesdays wednesdays thursdays and fridays. and then group them by date, so all mondays group with mondays all tuesdays group with tuesdays etc. now here is the problem it is only displaying SOME of the information. not all of the required records. here is my sql query SELECT so_0.Stat, so_0.SONo, so_0.CustLisg, so_0.ShipVia, so_0.Dt, so_0.PrtCmt FROM bigbusiness.so so_0 WHERE so_0.PrtCmt Like '%SHIP OUR TRUCK%' AND SONo > 332000 ORDER BY shipviaAdditional Details I want to dispaly EVERYTHING that is listed SHIP OUR TRUCK. once all of those are displayed I want it to sort by day of the week In the ShipVia section the options are OT-1.Monday, OT-2.Tuesday OT-3.Wednesday and so on5 mins agoand for some reason only one friday is being displayed when i know there are like 2-3 that should display |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-24 : 12:26:41
|
| how do you expect us to understand your issue without showing any sample data? There's no use in giving query as we dont have access to your system and neither can see your tablesSo please explain with some sample data which data is missing and what you expect to see as output.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
|
|
|
|
|
where is the rest of my data