Let's say I have a table with 650 columns and similar .NET class with
650 public properties.  There are 10,000 instantiated objects that give
the same number of rows in the table.  I loop through all objects
dumping them into the table.  This works fine from a functional
perspective.   Performance wise, it is very slow.  There are no indexes
on the table and it is rarely used.  The column types are int and
varchar.

The reason such a table exists is to write it out to a flat file and
send to another entity requiring such a format.  Is there a better way
to do this than one monolithic table?

Thanks,
Brett

Single to Multiple columns
Assistance with SQL Script
SQL 2005: Why does DECLARE varchar(MAX) in Stored Procedure not work?
HOW TO: PIVOT for unknown number of column headings?
Passing parameter from a recordset in a Stored Procedure