For anyone who gets this, I half created an SSIS package and renamed it. This is what caused the issue, once I renamed the package back again everything worked ok.

I eventually got this working just by reading in the passwords again and deploying. Very odd as to why it wouldn't work.

Thanks for your help.

Sorry for my delay, I had yesterday off. Thanks for this, I will look through all the suggestions this morning and then let you know which one(s) I incorporated. Really...

Hi John, I get the arithmetic, I was unsure how to construct the query to get the values as this. Apologies if I am being dim, it seems straightforward in...

Hi John,

Thanks for your reply, you might have lost me on that one could you explain that further?

Chris the datatype is datetime for that field if that helps.

Thank you so much Gianluca it is appreciated. I was getting mind boggled by the 30 minute thing. I did change the query slightly to this:

select convert(char(11),close_date, 103) as...

No worries, my apologies here is more data (hopefully).

So the table is like this with the fields I will need to pull this data for the query:

callrefdate_timeevb_recipient_email

49898711/06/2015 08:22:04NULL

49974812/06/2015 13:24:33NULL

50471619/06/2015 15:21:11NULL

50730325/06/2015...

Thank you Mr Magoo, gosh I am rusty!

That is correct, I went into Security on the folder settings as normal and added the user. They appeared in the Security of both yet he can click on...

Thanks both, the data source has its own id so that's fine.

It should be inheriting this from the parent folder but it's not. It's very odd as normally you can...

Apologies I was running the query per month just...

Hi Steve,

Dang they keep calling me an expert don't tell me I did something right? 😉

When I added with rollup to the end of the group by piece, it listed...

Thanks all, really appreciated!

Thanks SSC will take a read!

Twin Devil yep, only they need to be able to specify as many words as they want, hence why the query is the way it...

Apols perhaps I wasn't clear.

What they (management) want to be able to do is search on the initial description from the user to find out how many calls were raised...