damixa
asked on
sql query to insert the fibonacci sequence into a table
I need an insert statement to insert the fibonacci sequence into a table. Lets think for a moment that the table has two fields
fibid - is an integer, identity field
fibnum is where the fibonacci sequence should go.
so it will be something like this
fibid(1,2,3,4,5)
fibnum(1,2,3,5,8)
etc
lets say populate 200 records
thanks,
Vinnie
fibid - is an integer, identity field
fibnum is where the fibonacci sequence should go.
so it will be something like this
fibid(1,2,3,4,5)
fibnum(1,2,3,5,8)
etc
lets say populate 200 records
thanks,
Vinnie
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
But for a novice and easy to understand the below is the best approach
Step 1 : Create a table fibonacci with the required fields
step 2 : create a loop
Step 3 : caliculate the current fibonacci number
step 4: Store it in the table
Open in new window