Given that option 2 changes the column to allow nulls, and that was not desired, I believe "Option 2 will fail" is the best answer.

-at

That's great, thanks Steve - both good articles.

Thanks,

Andrew

Hi Steve

Thanks for taking an interst in this.

The rows in the resultset are not very wide - 20 columns that total, at most, 376 bytes each. That's a maximum total...

Hi Steve

When I say the report is large, I'm not kidding - the stored procedure returns about 180,000 rows.

The report contains a single matrix control, which does a GROUP BY,...

Hi David

We're rebooting the whole server to add the new RAM, so yes, I am restarting IIS.

Thanks,

Andrew