Post reply

Problem with case statement from sql server to visual studio 2005

  • March 2, 2012 at 7:38 am

    #256903

    I'm having an issue where my case statement works fine in sql server but in visual studio (I don't receive an error) it produces incorrect results.

    This is the case statement in both VS and SQL server:

    select

    rsda.name as BU,

    rsu.last_name as LastName,

    rsu.first_name as FirstName,

    ld.name as Department,

    case lab.max_hours_per_week

    when '98.00' then 'SME'

    when '99.00' then 'NSME'

    when '100.00' then 'SME32'

    end as MaxHours

    Where it says when '100.00' then 'SME32' - in sql server I'm getting the correct results, which is SME 32, but in VS it's dropping the 32 and just using the SME.

    Any Ideas as to why this may be happening?

    KCCO,

    jess.

  • March 2, 2012 at 7:44 am

    #1454177

    --Removed

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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