I'm struggling to find anything other than a complex stored proc to do this:
Out of a group of 20 columns return the rows in which:
1. Only 1 of the 20 columns IS NOT NULL2. More than 1 of the 20 columns IS NOT NULL
Any ideas?
gvim