INSERT INTO StudentHistory(1,100,2,2013,GETDATE(),'2013-02-01 12:00:00 ')

INSERT INTO StudentHistory(2,100,2,2013,GETDATE(),'2013-02-01 12:00:00 ')

INSERT INTO StudentHistory(2,101,2,2013,GETDATE(),'2013-02-01 12:00:00 ')

INSERT INTO StudentHistory(2,102,2,2013,GETDATE(),'2013-02-01 12:00:00 ')

INSERT INTO StudentHistory(2,103,2,2013,GETDATE(),'2013-02-01 12:00:00 ')

INSERT INTO StudentHistory(3,103,2,2013,GETDATE(),'2013-02-01 12:00:00 ')

INSERT INTO StudentHistory(3,104,2,2013,GETDATE(),'2013-02-01 12:00:00 ')

INSERT INTO...

Hi, Thanks for the reply

here goes the example

Source Table

CREATE TABLE StudentHistory(

StudentHistoryId int IDENTITY(1,1) NOT NULL,

StudentId VARCHAR(6) NOT NULL,

DepartmentId VARCHAR(5) NOT NULL,

ProcessedMonth INT NOT NULL,

ProcessedYear INT NOT NULL,

ProcessedDate DATETIME NOT NULL,

InsertedDate...