Feb 062013
 
select soldiers
from   men
model  
dimension by (
  bravery, strength, cunning, tactics
)
measures (soldiers)
rules (soldiers[
 bravery  >= 'To the point of stupidity',
 strength >= 'A rampaging grizzly on steriods',
 cunning  >= 'Dr. Fox professor of craftiness',
 tactics  >= 'Outmaneuvered Sun Tzu as a baby'
 ] = 'Y'
);
Now if I can just get the model clause to generate these for me, the world will be mine! (cue evil laugh)
Get SQLfail sent to your inbox

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>