Matt,
If you're using a stored procedure for this process, you can use the following
to grab the ID of a record that was just inserted from step 1 in order to use
it in step 2:
Declare @New_ID int
-- do your personnel insert here...
insert into personnel (....)
values (....)
-- Now get the id for the new personnel record.
select @New_ID = @@identity
Now that you have your new ID, use it when inserting the second record in the
personnelDetails table:
-- do your personnel details insert here...
insert into personneldetails (PersonnelID, ....)
values (@New_ID, ....)
If you're not using a stored procedure, you could run a select statement to get
the ID back after your insert from step 1, although there may be a chance that
2 records in the personnel table could have the same values.
Mark
Matthew Macdonald-Wallace <[EMAIL PROTECTED]> wrote:
Hi all,
I thought I'd introduce myself before I start begging for help!
I'm just about to recommence a career in IT and am currently training
to get the MCP.net/MCAD/MCSA/MSDBA qualifications. I have a linux
background and am very keen to see how well I can integrate MS
products and Open-source alternatives through the .net framework. My
knowledge of C# and the ASP platform is no-where near as good as my
skills in other languages, but there we go, that's life! :)
My question is as follows:
I'm currently trying to insert data into a number of tables in a MSSQL
Server database. My current logic (and this is not yet in code!) goes
something like this:
1. Insert the user's Firstname, lastname, emailaddress and password
into the "personnel" table.
2. Extract the new users ID from the "personnel" table and use it to
insert their postaladdress, phonenumber, fax number into the
"personnelDetails" table.
3. using the postcode from the "personnelDetails" table, suggest a
branchId (through a "SELECT * FROM branches WHERE branchPostCode LIKE
%postcode%" kind of thing...)
4. add them to the selected branch.
If anyone can help me get around this, that would be great. The main
issue is with step 2 and extracting the person's ID.
Thanks in Advance,
Matt
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspNetAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
