Carl, I was thinking the exact same thing. Thanks Steven! -----Original Message----- From: Carl Von Stetten [mailto:[email protected]] Sent: Tuesday, February 04, 2014 2:08 PM To: sql Subject: Re: sql query help
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:3535 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
