Hi guys.

I actually got it right since I knew from the answers which options I could definitely do with temp tables but I took my time before answering.

I've read several times that this actually is possible, even if it would make no sense to do it.

Not saying it's true. I'll give it a try when I have the time.

Link:

http://sqlfool.com/2008/11/partitioning-101/