Oooohhhhh! Nice. I had thought about doing something with CASE, but I've never used CASE with multiple conditions like that before. I learned me something new today. :-)
-Carl V. On 2/4/2014 10:49 AM, DURETTE, STEVEN J wrote: > Actually it can be accomplished with a case statement. I'm assuming this is > T-SQL: > I also accounted for a missing Winter tier for Grade 8 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3534 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
