Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting.

What I would like to do is calculate the values in the SQL Query instead so that I can sort by those columns. How do I assign values based on other fields to a temporary field name?<P>Hope this ...