Thank you to everyone for your help and time in this post.

Great, thanks for the tip Thom. I managed to get it done.

alter VIEW [dbo].[CarouselDailyMileages] AS

SELECT

DATENAME(DW,J.DELDATEANDTIME) AS [WEEKDAY],

J.DELDATEANDTIME AS [DATE],

isnull(J.colpostcode,'EMPTY') + '...

There is a slight problem in that if J.DELLPOSTCODE is blank in the database it seems to not put any post codes at all in the destination field it doesn't...

Awesome thank you Chris, that seems to have done the trick for me.

Hi Phil,

I have removed that line and it's got the problem where it takes a long time to run again and puts a lot of postcodes repeating in the "destination"...

Hi Chris,

This is how it is currently....

alter VIEW [dbo].[CarouselDailyMileages] AS

SELECT DATENAME(DW,J.DELDATEANDTIME) AS [WEEKDAY],

J.DELDATEANDTIME AS [DATE],

(J.colpostcode +...

I think the reason it's taking so long to run is that I have put that line in the wrong place.

Whats happening now is that if a job has extra...

I decided to just let it run this time instead of killing it and it is working it just takes about 5 minutes to run. Brilliant. thank you

Ok Thom, no problem. Thank you taking the time to help me out.

I use the view to get the bulk of what I need that allows me to use a simple query in SSRS. This is the query in SSRS

SELECT

CarouselDailyMileages.WEEKDAY

...

it is something to do with that line

WHERE J.JOBID IN (SELECT sq.JOBID FROM dbo.Drops sq)

that it doesn't like

No graphics. It's as if it's stuck in an infinite loop of some sort. It's only a small report that they export to excel and it's filtered down to just...