Home Forums SQL Server 2008 T-SQL (SS2K8) Need suggestions on dividing two rows within a CASE statement RE: Need suggestions on dividing two rows within a CASE statement

  • July 28, 2014 at 1:06 pm

    #1732989

    I don't understand. You say you need to divide the result of a CASE statement, but the result is a string. What are your expected results? A CTE or a subquery could help you to work with the CASE statement as a simple column.

    If more help is needed, please post DDL and sample data for [TIM_PurchaseOffer] table.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2