Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Logic failure question

Author  Topic 

osirisa
Constraint Violating Yak Guru

289 Posts

Posted - 2009-11-04 : 10:01:32
Hi Group:

I have a question regarding the best way of Inserting in two tables.
Ok.
1. I have a front End with a drop down list pulling from an Active Directory Table contains all Employee Name.
2. I have another database with an Employee Table that contains less than 10% of the Total of Employee and instead of having an Employee Id. It has an auto generate number id for every new entry.
3.I have to be able to INSERT in the Employee Table a new Employee pulling from Active Directory and generate a sequence number.

Any help will be greatly appreciate it.

Thank you.
   

- Advertisement -