Next CallDateTime information is in the data but its not called Next CallDateTime, its CallDateTime.

So if records 1 CallDateTime was after the select date e.g 01/05/2013 then they revisited on the 05/05/2013 and then 10/05/2013.

on the nextcalldatetime i just want to see CallDateTime as 01/05/2013 & the next CallDateTime as 05/05/2013

[dbo].[History](

[HistoryID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[SystemID] [tinyint] NOT NULL,

[PID] [int] NOT NULL,

[Name] [varchar](35) NOT NULL,

[Source] [varchar](32) NOT NULL,

[SourceField] [varchar](32) NOT NULL,

[SourceID] [varchar](32) NOT NULL,

[CallDateTime] [datetime] NOT NULL,

[Num] [varchar](15) NOT NULL,

[CallData] [varchar](240) NOT NULL,

[ANI] [varchar](15) NOT NULL,

[RC] [varchar](5) NOT NULL,

[ID] [int] NOT NULL,