Will be simpler for me to do the package... give me a few hours, I have something else to do first.

Now I would call that a bug .

Thanx for the info.

Yes it does. If you read correctly I have a : for each field in myrs.Fields()

This will work if you have 0 to X nullable columns and...

Maybe you should drop him a line to have a confirmation... you wouldn't want to say something on his behalf that he doesn't approve of

When did he say that?

Before someone else complains (not you)

I'd still do it set based on dts :

Select col1, col2, coln ....

then using a...

Don't know either why it doesn't work, it should work with top 100 percent but it obviously doesn't.

As I said the tables have no order. You need to put...

Just change the 'No' to yes in the previous query to get the nullable columns (all others will have 100% so no need to count them).

Then the query would look...

Before someone else complains :

Select C.TABLE_NAME, C.COLUMN_NAME from Information_Schema.COLUMNS C inner join Information_Schema.TABLES T ON C.TABLE_NAME = T.TABLE_NAME where C.IS_NULLABLE = 'No' AND T.TABLE_TYPE = 'BASE TABLE' ORDER BY...

for questions A :

Select O.Name, C.name from dbo.SysObjects O inner join dbo.SysColumns C on O.id = C.id and O.XType = 'U' and C.IsNullable = 0 order by O.Name, C.Name

Count the number of non null fields per table?

or count the number of rows where the data is not null?

CREATE TABLE #PolicyList

(PlanNo Char(12) NOT NULL,

PolicyHolder1 Integer NOT NULL,

PolicyHolder2 Integer NULL,

CorrespondenceClient Integer NULL)

ALTER TABLE #PolicyList WITH NOCHECK ADD

CONSTRAINT PK_#PolicyList PRIMARY KEY CLUSTERED (PlanNo) WITH FILLFACTOR = 100

/* Code to populate...

Sure show me how to do this with the information_Schema views .

There are exceptions to the dynamic sql rule

Did you try the set based approach?

The real question here is... is it fast enough rom the application side to satisfy the needs of the users. If not then you have a problem, otherwise I...