Hi Tim,

> -----Original Message-----
> Are there tools to generate this or is there a better way
> than writing it all? This is esentially a procedure adding
> all data to a row in a table based on the primary key.

Although its still in Beta you could try using SPGen
(http://www.tectsoft.net/) its open source and very stable.

It can create the following types of procs:

~ Insert
~ Update
~ Delete
~ SelectAll
~ SelectPage (similar to first x skip x)
~ Select (single row based on id)

Rgds

Si Carter
http://www.tectsoft.net/