I have a table in which I have a date field and an identity field. I want to create values in an indexed bigint field consisting of the date in the form yyyyMMdd with the value of the identity column tacked on the end so that I can quickly identify the last record entered on any given date.
I want these values created as each record is created/saved.

Why not use a trigger and a third column with the created/modified date or
one column for create and one column for last modified?

--
Ray Higdon MCSE, MCDBA, CCNA
--
[quoted text, click to view]
to create values in an indexed bigint field consisting of the date in the
form yyyyMMdd with the value of the identity column tacked on the end so
that I can quickly identify the last record entered on any given date.
[quoted text, click to view]