Post reply

Math Functions within Case When

  • November 14, 2008 at 12:57 pm

    #898837

    Great yeah.. I will definitely try to use JOINS more than the where clause. I happen to alternate for some reason, but I'll try to stick to JOINS... I guess that's why they are there for! But thank you for the information and yes I did notice the parenthesis. 🙂

    --
    :hehe:

  • November 14, 2008 at 1:03 pm

    #898844

    My pleasure, glad we could help.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • November 14, 2008 at 1:06 pm

    #898848

    I find separating the join criteria from the filter criteria makes working with multiple table queries easier. Also, I would rewrite your current query using a CTE to replace the derived table. Would make the query even easier to read. You should give it a try.

  • November 14, 2008 at 1:27 pm

    #898862

    Most definitely Lynn. I guess i'll have to read abit about CTE tables over derived tables.. Thanks for the information 🙂

    --
    :hehe:

Viewing 4 posts - 16 through 18 (of 18 total)

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