Post reply

Consolidation of table

  • February 27, 2011 at 5:00 am

    #235746

    hi

    How can we check that the consolidated tables were generated correctly?

    Is there any tool in SQL?

    thanks

  • February 27, 2011 at 5:13 am

    #1292024

    daveriya (2/27/2011)

    hi

    How can we check that the consolidated tables were generated correctly?

    Is there any tool in SQL?

    thanks

    What do you mean by a consolidated table?! :unsure:

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • February 27, 2011 at 5:51 am

    #1292029

    for example,

    At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level.

    for example, for jan

    bank1_200901

    bank1_200902

  • February 27, 2011 at 2:01 pm

    #1292064

    daveriya (2/27/2011)

    hi

    How can we check that the consolidated tables were generated correctly?

    Is there any tool in SQL?

    thanks

    You do this by making sure that the code that generated the tables is working correctly. That is done by testing prior to release to production.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • February 27, 2011 at 7:28 pm

    #1292106

    daveriya (2/27/2011)

    At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level.

    If you just want to check the tables exist, look in the sys.tables view.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

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

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