Home Forums SQL Server 2008 T-SQL (SS2K8) Urgent Query help needed- calculate one field based on other field in SELECT statment RE: Urgent Query help needed- calculate one field based on other field in SELECT statment

  • April 13, 2013 at 4:46 pm

    #1606270

    dhananjay.nagarkar (4/13/2013)

    Hi Friends,

    I have reporting TSQL query- in this query within the select statement I have 2 fields 1) Age (working Days) and 2) Age Group(Working days).

    the requirement demands that based on the first Select field - Age(working Days) I, display one of these selections:

    0 - 29

    30 - 59

    60 - 89

    90 - 119

    120 +

    for the Second SELECT list field Age Group(Working Days)

    Note- the data Type for both is Varchar.

    thanks

    Dhananjay

    Sorry, but there really isn't enough enough information here to help you. Please take the time to read the first article I reference below in my signature block reading asking for help. It will walk you through everything you need to post and how to post it to get the best possible tested answers.

    Also, these sounds like homework as I seem to remember seeing a very similar post just a few days ago. If true, we would be more the happy to help you, but besides the other info we need we will need you to show us what you have tried so far.