Post reply

foeign key in table

  • April 1, 2012 at 3:32 pm

    #255868

    Basically I am tyring to decide how to load the history table on a daily basis. (The history table will contain all the daily transactions.)

    There will be 3 extra tables used to validate what data is loaded daily into the history table. The 2tables will be 2 foregin keys in the history table. The history table will be linked to the 3 other tables by having a foreign key for each table.

    How should I setup the bestg sql script?

    Will I drop the foreign key relationships first before I load the history table daily? Will I load the history table daily and not drop the foreign relationships.

    What is the best method of referring to the other 2 control tables? Do I just use an alter statement? Can you tell me and/or point me to a reference I can use to solve the problem?

  • April 2, 2012 at 7:52 am

    #1467629

    can you post the DDL scripts to create your tables and some sample data? if you are unsure how to do this please check the article that is linked in my signature for the proper forum etiquette on how to post questions. Thanks looking forward to helping.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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