2015/03/04 09:21 -0500, Phil
One option would be to create a trigger for each milestone to generate the
data instead. That could be a lot of triggers, not sure if it could be
done in a single trigger, plus then I would have to maintain the trigger
when adding new milestones.
Less
- Original Message -
> From: "Phil"
> Subject: Capturing milestone data in a table
> user_credits where metric1 > $mile and (metric1 - lastupdate) < $mile)
That second where condition is bad. Rewrite it as metric1 < ($mile +
lastupdate). Better yet, combine them into a between compariso
