I&#039m successfully inserting into a db using a stored proc, but I need to replicate the ClientID to 10 other tables. For some reason, this one is escaping me.<BR><BR>After a successful insert, I then use:<BR><BR>SELECT @@IDENTITY ClientID<BR>SELECT @ClientID = @@IDENTITY<BR><BR>INSERT INTO table2<BR>(ClientID)<BR>VALUES(@ClientID)<BR><BR>I NSERT INTO table3<BR>(ClientID)<BR>VALUES(@ClientID)<BR><BR>I NSERT INTO table4<BR>(ClientID)<BR>VALUES(@ClientID)<BR><BR>T he insert ClientID into the other tables is not being inserted. I added SET @ClientID = @@IDENTITY and it made no difference.<BR><BR>Thanks for the help.<BR><BR>Alan