DECLARE @Table TABLE (ID INT,CallID INT,CallNotes VARCHAR(50), CallDate DATE, AssignedTo VARCHAR(20))
INSERT INTO @Table
VALUES
(1, 1, 'IT text Test 1', '27/04/2015','Mark Cobb'),
(2, 1, 'IT text Test 2', '27/04/2015','Mark Cobb'),
(3, 2, 'Test Text 1'   , '27/04/2015','Mark Cobb'),
(4, 2, 'Test text 2'   , '27/04/2015','Mark Cobb')



select t1.CallID,t1.CallNotes,t2.CallNotes
from @Table t1
cross apply (select top 1 callnotes 
             from @Table
             where t1.CallID = Callid
             and t1.ID < ID
             order by id desc
             )t2

quote:

---

Originally posted by cobby1812

so for each item added I can return the history of the call...

---