>If NULLS are the problem, you could replace null values in your select statement by using the ISNULL clause for the columns that could have a NULL value and replace with a space as follows:
>
>select isnull(columnName, ' ') as columnName
>
Yes, that's what I done, however, I'm now thinking that the values will become not null in return causing insertion of an extra record. I'll try to update my SP to make sure to only take real data back.
I'm also thinking the problem had to be with bit (Boolean) fields. Somehow checked property doesn't want to be null, I'm thinking.
If it's not broken, fix it until it is.
My Blog