Hello,

I have a stored procedure that gets it's data from a View in SQL
server:

Select "WO Number", "Part Number", "Complete Date", "WO Quantity"
Where [Work Center] Like @WorkCenter
Order By [Complete Date] ASC

I have code in my client app that returns this as a recordset.
However, I would like to add a column to the recordset in the stored
procedure.  That way when the client app gets the recordset, it
contains the extra column.

I am aware of this syntax for adding a column to an existing table:

ALTER TABLE table_name
ADD column_name column-definition;

....but since I am not dealiing with a "set" or pre-existing named
table, it fails.

I would appreciate any suggestions.
Thanx!

Clustered Index Not Working
Select distinct problems
Top 1 query problem
How to compare two tables of same structure using a hash/checksum
SELECT/INSERT SELECT performance issue