forrest77 (4/24/2015)

---

Lynn, this is the table.

CREATE TABLE [dbo].[EditLog](

[Id] [INT] IDENTITY(1,1) NOT NULL,

[EditDate] [DATETIME] NOT NULL,

[PlanId] [INT] NOT NULL,

[TransId] [INT] NOT NULL,

[EntityId] [INT] NOT NULL,

[QtyPrior] [FLOAT] NULL,

[QtyAfter] [FLOAT] NOT NULL,

[Description] [VARCHAR](255) NULL,

[NoteText] [NVARCHAR](MAX) NULL,

CONSTRAINT [PK_EditLog] PRIMARY KEY NONCLUSTERED

Here is some sample data

IdEditDatePlanIdTransIdEntityIdQtyPriorQtyAfterDescriptionNoteText

837652015-04-23 19:42:19.51715206353236810.6578947368421050.789473684210526EDITchange from 18 to 25

837662015-04-23 19:42:19.64315206353250810.6578947368421050.789473684210526EDITchange from 18 to 25

837672015-04-23 19:42:19.74015206353209810.6578947368421050.789473684210526EDITchange from 18 to 25

837682015-04-23 19:42:19.88315206353218310.6578947368421050.789473684210526EDITchange from 18 to 25

837692015-04-23 19:42:20.00015206353191410.6578947368421050.789473684210526EDITchange from 18 to 25