You can use union
SELECT dtDate FROM timesheets
UNION ALL
SELECT GETDATE()
>In a stored procedure, is there a way to add more rows to the result of a select statement?
>
>Something like this..
>SELECT dtDate FROM timesheets
>INSERT INTO ????? (dtDate) VALUES(GETDATE())
>
>The purpuse of this result set is to get a list of dates for read only purposes.
>
>Thanks,
>
>Chris
--sb--