Hi Guys, My question is probably best described by example. Is it possible to indicate that on a particular day, the total number of “events” were zero.
// Three events today update mytable count=count+1 where day=“20140101” update mytable count=count+1 where day=“20140101” update mytable count=count+1 where day=“20140101” update mytable count=count+1 where day=“20140101” // Two events today update mytable count=count+1 where day=“20140102” update mytable count=count+1 where day=“20140102” // Zero events today, so do a count+1 and count-1 to get a zero update mytable count=count+1 where day=“20140103” update mytable count=count-1 where day=“20140103” I need to be able to distinguish between knowing if zero events occurred on that day, or no processing of data occurred on that day. Thanks, Jacob
smime.p7s
Description: S/MIME cryptographic signature