sankar.nandakumaran (7/25/2012)
Hi...Thanks for the code , but here employee master table should contain only one row and emplioyee detail table can contain n rows. we have chech whether empcode is unique also .
Thanks and Regards
Sankar
You can add any number of rows in the Employee Detail table if you don't have any UNIQUE constraints the empcode column
Since, you said empcode is a PRIMARY KEY in the Employee Master table, the uniqueness check will be performed automatically if you define it as a PRIMARY KEY.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/