Insert Child records for Matching ParentID

Last Post 24 Aug 2007 10:27 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
boonchiat
New Member
New Member

--
13 Jun 2007 12:05 AM
I have two table with the following structure

Table Parent
-ParentID
-FullName
-Telphone

Table Child
-ParentID
-VisitDate
-VisitDescription

I need to insert records from temporary table into the table child if the temporaly records parentID matches the table parent's ParentID.
SQLUSA
New Member
New Member

--
24 Aug 2007 10:27 PM
More business like description:

Parent --> Patient

Child --> Visit

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/order2005grandslam/ - The Best SQL Server Training in the World
You are not authorized to post a reply.

Acceptable Use Policy