#DateForumTypeThreadPost
923 Jun 2015 @ 03:10 PDTDatabaseTopicSumming two rows in one This SQL  SEL ORIGIN,DESTINATION, COUNT(PAX) GROUP BY 1,2 provides the output below.   ORIGIN Destination Count WAS LAX 120 LAX LAX 80 LAX BOS 42 BOS MIA 101 MIA BOS 93 B...
802 Jan 2015 @ 09:47 PSTAnalyticsReplyAdding a row for a non existing transactionHello Dieter, As you may see in my simplified SQL below, I am left joining but the problem is that there is no record for sales if sales does not happen for a particular brand in that month. ...
727 Dec 2014 @ 09:02 PSTAnalyticsReplyAdding a row for a non existing transaction Correction to the above...please ignore the second table above   the desired table looks like below   YRMTH Supplier Store WEEKDAYS/WEEENDS Shipment Brand Sale MNTHLY_...
626 Dec 2014 @ 01:51 PSTAnalyticsReplyAdding a row for a non existing transaction   YRMTH Supplier Store WEEKDAYS/WEEENDS Shipment Brand Sale MNTHLY_TTL EXP COUNT 201309 OWN A W North B 1 13 5.5...
525 Dec 2014 @ 08:51 PSTAnalyticsReplyAdding a row for a non existing transactionMy client wants the count of items from store “A” aggregated by weekday/weekend sale, by grocery and brand.  I need also to add the expected count which is calculated by multiplyin...
425 Dec 2014 @ 08:48 PSTAnalyticsTopicAdding a row for a non existing transaction
317 Jan 2014 @ 12:20 PSTDatabaseReplyCase statement not pulling time between 18:31:01 and 19:00:00It pulls everything except the time slot between 18:31 and 19:00.
211 Nov 2013 @ 09:25 PSTDatabaseTopicCase statement not pulling time between 18:31:01 and 19:00:00My data has four columns date, departure, destination and depart time. I have a case statement that groups depart times. It works fine but it does not group departures between 18:31 and 1...
121 Jun 2013 @ 05:33 PDTDatabaseTopicFastload errorI am trying to load a | delimited file and I am getting the following error ....   "error on piom get row : 60 text:column length error , row not returned". Can you pleas...