Hi Remi,

Thanks! Success, but not complete. It updated 1617 (about half-way) when it gave me an error:

Error Code: 0

Error Source = Microsoft OLE DB Provider for SQL Server

Error Description: The...

Hi Jorge,

I like the approach, but it didn't work right out of the box, so I adapted it a bit. After reading the article that Remi pointed me to I...

Hi Remi,

Thanks. The last part is not part of your code. Just me trying again to make progress my way (and failing).

R

Well, after several attempts with Remi's code I still don't seem to be able to get it working. Somewhere in the code is a problem (I think it is in...

WOW!

No wonder I didn't understand. I am going to be studying this and try to emulate bits and pieces into some other routines I am working on.

Thanks a million!

Ron

Hi Remi,

Sorry but supper interfered here.!

Thank you very much for your offer. I really appreciate it. I will dissect it also so I...

Sorry Remi,

I read your suggestions a couple of times but I think I reached the limit of my SQL skills. I have not worked with record sets yet (cursors was...

No complaints at all, but certainly very interested in the suggested solutions. My own SQL programming skill is, compared to what I am reading, sub-standard so I am trying and...

Hi Remi,

Clarification required, I did not express myself clearly there! I need to know the so-called field fill factor. I therefore need to know per field the number of non-null...

Thanks David/Remi,

No, I didn't try the set approach as accuracy is required. This particular script is the first of a few more.

I am trying...

Hi David/Remi,

The additional quotes did the trick! Thanks very much

Ron