I want a new sql command...

I was going to send this to sqlwish, until I saw that sqlwish was no longer around.

I want a command called something like "Cut" where it will insert the desired records into a destination table while deleting from the source table. this would streamline for me the archival of history data from my transaction tables.

Just throwing it out there.

As you discovered, SQLWish has been deprecated. You can now make suggestions, product enhancement requests, etc., at:

Suggestions for SQL Server

http://connect.microsoft.com/sqlserver

|||The OUTPUT clause doesn't do that? Would someone please check this; I cannot verify this right this minute.|||

I found this fragment:

delete from Production.ProductDescription
output deleted.ProductDescriptionID
where Description = 'DBAzine OUTPUT clause demo'

ProductDescriptionID
--
2014

(1 row(s) affected)

at this website:

http://www.dbazine.com/sql/sql-articles/cook18

Is this in line with what you are looking for?