set targets
Hiya
want to write an insert statement, that includes a set target number
e.g
main table
insertinto TestTable values (1, 1.0) 1.0 is 100 %
target table
insertinto TargetTable values (1, ****0.0****)
I want to change the ****0.0**** to be a target value of
1. 50%-100% or
2. <50%
I will then compare the main table data to the target table data
how would I go about this please
Kind Regards
|