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