SQL

There are 1 entries for the tag SQL
SQL Trickery: Rank and file your data with CTE, Rank, Case and Partition

Often as the case may be where you get a request from one of “those” people in the glass offices who like to wear suits and ties, take power lunches and talk with their hands for a particular set of data that just seems.. odd. But being as the situation often is, “those” people control your pay checks, so you feel obligated to oblige their whims… Let’s say you have a table in your data base that holds commission rates for sales people, and the dates those commissions are effective on.  It might look something like this: ...

posted @ Saturday, May 09, 2009 4:46 AM | Feedback (0)