Post reply

query

  • January 10, 2007 at 8:52 am

    #682408

    Hmmm... I'm not sure I follow you.

    First, you did not mention datatypes of the columns, primary keys and other useful info about data contained in them. Second, you did not describe relations between these 3 tables (how these tables can be joined together).

    Well, and then the rules ... I can understand the conditions, but what "Waiverofpremium will be valued at ..%" means? Do you want to write this info somewhere, or just display it with a query? Or does it mean that some column should be updated to hold x% of the original value?

    Is the "Note" the actual requirement(=it must be done this way), or is it just some casual remark how someone thinks it could be done?

    Please, try to supply the missing info about data structure and explain better what you would like to do, and what would you like to hear from us.

  • January 10, 2007 at 11:16 am

    #682491

    1. What have YOU come up with so far?

    2. Why is there a requirement for a temporary table?

    3. The way this is worded, especially the part about requiring a temporary table, makes this sound like schoolwork.

    -SQLBill

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

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