Home Forums SQL Server 2008 SQL Server 2008 - General SQL to divide one row by another row based on formula or rule. RE: SQL to divide one row by another row based on formula or rule.

  • March 21, 2013 at 8:07 am

    #1599393

    shashi.bi245 (3/21/2013)

    Thanks for the replay.

    I am having almost 600 records, so is there any other way to get the result without case statement.

    What hardware are you using to run your SQL Server on? ZX Spectrum?

    Even this one should process 600 records with no issue.

    Seriously, why do you think that CASE WHEN will effect performance?

    Or, I guess, you mean something else. Then please provide clear detailed requirements.

    Please check the link at the bottom of my signature to find out what really helps to ask your question in a way to attract most relevant and prompt help.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]