Lynn,

I included some data from the EditLog table in previous post.

I get the following error when creating the function

Msg 4514, Level 16, State 1, Procedure ADMC_DDL_GetUniqueEditLog, Line 25

CREATE FUNCTION failed because a column name is not specified for column 2.

Basically this is what I am trying to accomplish

I plan to create a view which require that I take attributes from the Editlog table (e.g., QtyPrior, NoteText) but I only want the most up to date line (which should one line) from the EditLog table.