Recursive table population from falt-file

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

SQL Server 2000 Forums

SQL Server Development (2000)

Recursive table population from falt-file

Author

Topic

JNOM
Starting Member

3 Posts

Posted - 2002-05-25 : 17:44:38

Hi everyone, I'm trying to populate a hierarchy structure from a flat-file but I'm stuck, really this is my first shot at it ever so any input from you guys would be great! I'm kind of hesitant as to where to start. thanks in advance

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-05-25 : 18:06:16

Got a sample of the file format, the data that's in it, and the table(s) structure(s) you're imorting into?

JNOM
Starting Member

3 Posts

Posted - 2002-05-25 : 18:12:12

Hey thanks dude,

Ok the source structure is:
TBL_Hierarchy
ID, group, category, family, line, model (those five are the hierarchy levels), DateNew, DateChenged, DefultProductManager

destination structure is
tblHiearchy
HierarchyID, HierarchyName, ParentID, and HierarchyTypeID which is comming form tblHierarchyType and that table is just the ID and Name

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources