Higgim, seriously thank you SO much! I played around with bits of each item but couldn't get them all together in my head.

Changed it to this as all I really...

Higgim thanks, almost there!

Pulling the data with the right date but now doing each call per time of the day whereas I need calls for that week:

Week CommencingMonthYearTotal

2014-02-02 08:30:42.000February20141

2014-02-02 08:39:27.000February20141

2014-02-02...

Well I think we are getting there, the wrong dates haha but not sure if maybe my query is wrong? I put in the date as the beginning of this...

Thanks for your reply.

So the data currently looks like this:

WeekMonthYearTotal

6February2014212

7February2014191

8February2014256

9February2014287

10March2014194

11March2014183

12March2014199

13March2014200

14March201442

What I want it to look like is this (currently I am manually adding in the dates based on the week...

Thank you, I meant to update this on Friday and say I had tested this and had no issues at all :).

*Runs off to have a good play*

Thank you, thank you so much! I did wonder if to put as **** at the end, but wasn't sure.

This has helped me alot, really appreciate it

I just got this error:

Msg 102, Level 15, State 1, Line 24

Incorrect syntax near ')'.

Ok I tried this:

SELECT CAST(AvgMins/60 AS VARCHAR(10)) + ':' + RIGHT('00' + CAST(AvgMins%60 AS VARCHAR(10)), 2)

FROM

(SELECT

AVG(fix_time/60) AS AverageFixTime,

SuppGroup AS SupportGroup,

DATENAME(MONTH,date_time) AS [Month]

FROM

calltable

WHERE

suppgroup IN ('WEBS', 'Tech','SQL')

AND

status <>'17'

AND

date_time >=...

Thanks Anthony that really helps!

How would I add in converting the time again? Currently it is in seconds and not MM:ss as it was before?

What I basically need to do is pull out the data for the last 3 months on average fix time for all calls but it needs to reflect each team....

Thanks Andy, will give it a try.

When you say overcomplicated...what do you mean? Always looking to improve , this query is quite old now (I had to dig it out...

Hmm only one small problem....it doesn't show the column for the suppgroup as well, just the column with the value in it.

Looks like this:

(No column name)

9:01

5:39

4:29

What I needed was a...

Thank you very much, I hate colds they make my head fuzzy (my excuse and I am sticking to it!)

Thank you both for your replies :).

rhythmk ironically I did post first on a MySQL forum but got told it might be more SQL Server as it is a linked...

Hi Steve,

Thank you I am still learning about what information to provide on here, so apologies if I didn't give enough and I will try to provide more. What information...