keep in mind that lutz' version will keep the identity on the deed_id column. Given the usage you're describing it shouldn't make a diffierence, but this means the DEED_ID would increment if another row were to be inserted, and not the new rownumber.

If that doesn't fit your usage, you'd have to explicitly pass the columns from the table, using

cast(deed_id as int) deed_int

to "disable" the identity from the existing column.