There are too many values from the sub-query select list.

The number of columns in the target of the INSERT operation exceeds the number of data values you supplied. Modify the query to include one value for each column.

See Also

Concepts

Error Messages in Visual Database Tools

Help and Information

Getting SQL Server 2005 Assistance