Olaf Stein <[EMAIL PROTECTED]> wrote on 03/27/2008
01:16:43 PM:
> Hey all,
>
> I have a table with 40 columns. If for a record a value is not available
the
> column is set to NULL. Is there a quick way of finding out how many
records
> have a value (NOT NULL) for 90% (or lets say 35 columns) o
Thanks.
But that means I have to type all 40 column names, which I what IU was
trying to avoid
Olaf
On 3/27/08 1:34 PM, "Rob Wultsch" <[EMAIL PROTECTED]> wrote:
> On Thu, Mar 27, 2008 at 10:16 AM, Olaf Stein
> <[EMAIL PROTECTED]> wrote:
>> I have a table with 40 columns. If for a record a value
On Thu, Mar 27, 2008 at 10:16 AM, Olaf Stein <
[EMAIL PROTECTED]> wrote:
> I have a table with 40 columns. If for a record a value is not available
> the
> column is set to NULL. Is there a quick way of finding out how many
> records
> have a value (NOT NULL) for 90% (or lets say 35 columns) of th
Hey all,
I have a table with 40 columns. If for a record a value is not available the
column is set to NULL. Is there a quick way of finding out how many records
have a value (NOT NULL) for 90% (or lets say 35 columns) of the columns.
Thanks
Olaf
- Confide
