Math Functions within Case When

Question

Math Functions within Case When

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

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

Slick84 SSCertifiable Points: 5602 More actions · Answer 1

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:

Garadin One Orange Chip Points: 29613 More actions · Answer 2

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]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

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.

Slick84 SSCertifiable Points: 5602 More actions · Answer 4

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

--
:hehe: