List:General Discussion« Previous MessageNext Message »
From:Andy Harrison Date:January 5 2001 7:25pm
Subject:Incremental Table Population via sql statement?
View as plain text  
Basically, I'm wondering if there's a way to do something like this...

foo     bar     10     20     30
foo     bar     10     21     30
foo     bar     10     22     30
foo     bar     10     23     30
foo     bar     10     100    30

in a single sql statement.  Most of the data stays the same, with the
value of one field getting incremented up to a certain value.

Thanx in advance. 

Andy Harrison
ICQ: 123472  AIM/Y!: AndyHarrisonRR
Incremental Table Population via sql statement?Andy Harrison5 Jan