Determining table insert order

Question

Determining table insert order

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95461 More actions · Answer 1

This link provides some information that might help you out.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 2

Most tools that do stuff like this drop the FKeys, insert the data and then re-add them.. Once you get enough tables involved, I'm thinking this isn't such a bad idea..

CEWII

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 3

The script on the link below will give you what you want.

Find Table Reference Levels

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72957