Well,

If you built up a temporary table in a stored procedure, formatted exactly as you require, then returned that, then you would not have any problems with storing the same...

Just a couple of questions:

I presume you actually want:

1 2 3 4 1

4 5 6 null 1

7 8 null null 2

in...

You could have a view based on the data, using the following expressions:

For proper case on first name and last:

UPPER(SUBSTRING(first_name, 1, 1)) + SUBSTRING(first_name, 2, 255) AS first_name

For upper case...

Thanks guys - When I run the execution plan on the SP, it tells me it is going to use a clustered index scan - which sounds OK to me....