i hv functional process (business logic ) as follows


sql="select * from ...."

rs.open "sql"

do while not rs.eof()
calculateAmt=calculateQamt(rs("field1"),rs("field10"))

If caculateamt>0 then
myval=do some events
else
myval=do some Events
endIf
rs.movenext
end loop

if myVal>0 then
runStoredProcedure for Insert
else
runStoredPrcodure for Update
endif

------------------------

for this
1.do i need to write everything in StoredProcedre?
2.write everything in COM?
if i write rs.movenext,rs.open is this good approach

Which is the best approch for n-tier arch.
Help me