KoldCoffee (5/30/2013)
Still.....if I weren't unpivoting then I wouldn't have a solution. I wonder....how would I do the equivalent of this?where
[Month 01] is null and
[Month 02] is null and
[Month 03] is null and
[Month 04] is null and
[Month 05] is null and
[Month 06] is null and
[Month 07] is null and
[Month 08] is null and
[Month 09] is null and
[Month 10] is null and
[Month 11] is null and
[Month 12] is null
How about:
WHERE COALESCE([Month 01], [Month 02], [Month 03], [Month 04]
, [Month 05], [Month 06], [Month 07], [Month 08], [Month 09]
, [Month 10], [Month 11], [Month 12]) IS NOT NULL
- Les