Billy - I would use a stored procedure to do this. Every insert and update I do is through a stored procedure. You can save the first table, then query...

Thanks - This does work for what I am trying to do.

I changed the From clause to

 FROM Test t1 INNER JOIN

         Test t2 ON t2.ID > 1 AND t1.ID =...

Hi - Your "b" table has a field "tableb_tablea_id" that needs to be populated with a value related to your "a" table. Your 

   insert into dd1(tablea_value, tableb_value)

   values('eee1b','eee1b');

does not...

You want to truncate the value to 2 decimal places

Multiply by 100, convert to an integer then convert to a Numeric(18,2) (or currency) and divide by 100

CONVERT(Numeric(18,2), CONVERT(int, <value> *...

Thanks - But if I can't figure out how to name the CONSTRAINT in the first place, I won't be able to rename it either. If I list my constraints...

Thanks - That gets the "NOT NULL" job done but is there any way to name the CONSTRAINT as I try to get in the habbit of naming every contstraint...