OK...thanks for the clarification ; / )

Keith, both you and stej included the -recurse argument in the remove-item cmdlet. Is that really necessary? I tried it without and it worked which seems logical since remove-item is going to operate on what it is passed through the pipeline? But the fact that both of you included it in your example gives me pause. Am I missing something or am I right that the second recurse is not needed? Seth

Chris, GREAT comment and thanks for the insight. My company is considering hosting micro-sites for each of our customers. The customers will have very limited theming and extending options. They would definitely not be able to add modules. We are talking 1000s of site. In that circumstance do you think multi-tenancy could be made to work? Seth

I know that there are a LOT of questions on SO about CMSs based on .NET but I have just one specific question.

I know that DotNetNuke supports multiple site creation on one installation. Of the other wellknown .Net CMSs...

N2CMS Composite C1 Umbraco Orchard AxCMS

...do any of them support this feature out of the box (or with relative ease)?

BTW, if you know of some low-cost non-free CMSs that would support this feature don't hesitate to give them a mention (as long as they are built on the Microsoft stack.)

EDIT Just learned that this feature is called multi-tenancy...thanks David. Thanks for your answers. Can anyone give clarity on whether N2CMS, Composite, or AxCMS support multi-tenancy.

Seth

I know that there are a LOT of questions on SO about CMSs based on .NET but I have just one specific question.

I know that DotNetNuke supports multiple site creation on one installation. Of the other wellknown .Net CMSs...

N2CMS Composite C1 Umbraco Orchard AxCMS

...do any of them support this feature out of the box (or with relative ease)?

BTW, if you know of some low-cost non-free CMSs that would support this feature don't hesitate to give them a mention (as long as they are built on the Microsoft stack.)

EDIT Just learned that this feature is called multi-tenancy...thanks David.

Seth

Thanks...thought it would be something like this. How does this perform? Seth

Can you pivot two columns in a pivot query.

Suppose I have the following data...

CREATE TABLE JudgeScores (PerformanceID int, JudgeID int, Criteria varchar(10), StrengthScore decimal(9,4), StyleScore decimal(9,4))

--first team performance
--judge1
INSERT INTO JudgeScores (1, 1, "Stunts",        4.2, 1.1)
INSERT INTO JudgeScores (1, 1, "Jumps",         3.9, 0.8)
INSERT INTO JudgeScores (1, 1, "Tumbling",      4.5, 1.0)
INSERT INTO JudgeScores (1, 1, "Choreography",  4.2, 1.5)
--judge2
INSERT INTO JudgeScores (1, 2, "Stunts",        4.1, 1.1)
INSERT INTO JudgeScores (1, 2, "Jumps",         4.0, 0.9)
INSERT INTO JudgeScores (1, 2, "Tumbling",      4.4, 1.1)
INSERT INTO JudgeScores (1, 2, "Choreography",  4.2, 1.6)

--judge3
INSERT INTO JudgeScores (1, 3, "Stunts",        3.8, 1.2)
INSERT INTO JudgeScores (1, 3, "Jumps",         4.2, 0.7)
INSERT INTO JudgeScores (1, 3, "Tumbling",      4.3, 1.2)
INSERT INTO JudgeScores (1, 3, "Choreography",  4.1, 1.3)


--second team performance
--judge1
INSERT INTO JudgeScores (2, 1, "Stunts",        4.3, 1.3)
INSERT INTO JudgeScores (2, 1, "Jumps",         4.0, 0.9)
INSERT INTO JudgeScores (2, 1, "Tumbling",      4.6, 1.1)
INSERT INTO JudgeScores (2, 1, "Choreography",  4.0, 1.0)
--judge2
INSERT INTO JudgeScores (2, 2, "Stunts",        4.1, 1.1)
INSERT INTO JudgeScores (2, 2, "Jumps",         4.0, 0.9)
INSERT INTO JudgeScores (2, 2, "Tumbling",      4.5, 1.2)
INSERT INTO JudgeScores (2, 2, "Choreography",  4.2, 1.6)

--judge3
INSERT INTO JudgeScores (2, 3, "Stunts",        4.1, 1.1)
INSERT INTO JudgeScores (2, 3, "Jumps",         4.5, 0.9)
INSERT INTO JudgeScores (2, 3, "Tumbling",      4.4, 1.2)
INSERT INTO JudgeScores (2, 3, "Choreography",  4.2, 1.6)

I want to select the data so that it will pivot this data as follows

PerformanceID, JudgeID, StuntsStrength, StuntsStyle, JumpsStrength, JumpsStyle, TumbleStrength, TumbleStyle, ChorStrength, ChorStyle
1     1     4.2,    1.1,    3.9,    0.8,   4.5,   1.0,    4.2,     1.5
1     2     4.1,    1.1,    4.0,    0.9,   4.4,   1.1,    4.2,     1.6
...
2     1     4.3,    1.3,    4.0,    0.9,   4.6,   1.1,    4.0,    1.0
2     2     4.1,    1.1,    4.0,    0.9,   4.5,   1.2,    4.2,    1.6
2     3     ...

Can this be done with a pivot query. If not what is the best way to do it?

Thanks for your help

Seth