I am intested to know how the people who answered this correctly figured it out 🙂

IN 2005 this appears to answer point 1

Create

Table #XXXX(id int)

Select

*

Thanks Jonathan.

Thanks

Chris

As a related question is there an easy way

to combine selection criteria ie to find those people who speak ALL of German, French and English - rather than nested selects?

ie...