Christopher,

Thanks for the quick response. I don’t think I was clear on the current example, the way I have it displayed you would think that the attendee names were...

Thanks Adam it worked like a charm.

No problem Adam, thanks for the help I will try it in the AM

No this is not home work, it is a legitimate request, it may seem a simple problem to you but when one is unsure how to accomplish a particular task...

Grant,

Thanks a bunch, I rewrote the code in your format and it ran without the Null error even without the NOT NULL statement.

Thanks for the tighter code sample, I looked in the table the only NULL value is the very last row in the table and all the fields are NULL would...

Lucky,

Thanks for the reply, therein lays the problem, there is no SQL Server Business Intelligence Development Studio in the Microsoft SQL Server 2005 group. I have installed the workstation tools...

Thanks for the response, but there is no Visual Studio thats the problem there seems to be no shortcut or executable to run. I have Microsoft SQL Server 2005...