Post reply

Using date and CASE

  • September 7, 2011 at 11:13 pm

    #1378363

    Ok, Share the scripts to create the table and test data. so that i can simulate the same on my machine, This would help me to help you.

    Thanks

    Ashok

  • September 8, 2011 at 8:47 am

    #1378609

    Apart from individual DDL and test data, your logic seems incomplete. I would revisit this and better explain what the process is for computation.

    You can use CASE for some of this.

    CASE when day = 1 and month = 'Jan' then 0

    when day > 1 and month = 'Jan' then hours * rate

    end

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

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