Thank you again

Thanks GilaMonster, can you also confirm if it will capture variable values? When capturing queries in the QueryData table they seem to start like (@P1 nvarchar(4000), @P2 nvarchar(4000),... And then...

I agree it is bizarre but it is the way the script currently works and they do not wish to change it.

I would need it to show as below

1 2015-07-01 07:00:00.000 NULL NULL

2 2015-07-01 09:00:00.000 2015-07-01 09:30:00.000 2015-07-01 10:00:00.000

3 2015-07-01 06:00:00.000 2015-07-01 06:45:00.000 NULL

4 2015-07-01 04:00:00.000 2015-07-01 05:00:00.000 2015-07-01 06:00:00.000

4 2015-07-01 04:00:00.000 2015-07-01 05:00:00.000 2015-07-02 06:00:00.000

Does anyone have any ideas?

Thanks

Sam

Thank you all for the suggestion, however If I was to run the following

INSERT INTO #Data

VALUES

(4,'Got Dressed','2015-07-02 06:00:00.000')

And then run my query, It would show me two entries for PersonID...

Thanks for all your help. The issue is that it is using a view that pulls from multiple tables and it does bring back some duplicates.

I am not even sure...

Hi

I amended your idea and came up with the following.

WITH Course

AS ( SELECT RandomId,

...

I have another similar one if anyone can help.

CREATE TABLE #Courses (RandomID INT, PersonID INT, CourseTitle NVARCHAR(200), CourseDate DATETIME)

INSERT INTO #Courses

VALUES

(1,1,'Maths','2015-05-01 15:30'),

(2,1,'Science','2015-05-01 15:30'),

(3,1,'Science','2015-05-01 15:30'),

(4,1,'Science','2015-06-01 15:30'),

(5,1,'Maths','2015-04-01 15:30'),

(6,2,'Science','2015-05-01 15:30'),

(7,3,'Science','2015-05-01 15:30'),

(8,4,'Science','2015-05-01 15:30'),

(9,5,'Science','2015-05-01 15:30'),

(10,6,'Science','2015-05-01...

Hi Phil

Thanks that worked.

Sam

Hi Kevaburg

No it does not.

Sam

Hi COldCoffee

That code works brilliantly.

Thanks for all your help!