.

Works like a charm nice one cheers

Ah my apologies the test data was not what i was supposed to post as they did not match the OptionsMapping table times, the updated test data for the DailyMedicalPlanItem...

it will all be completely wrong ha ha, no its ok this is not the fully finished code the season/year is taken into account later

I managed to figure it out anyway cheers

Select playerId,

IsNull(p.firstName+ ' ','') + IsNull(p.MiddleName+ ' ','') + IsNull(p.LastName,'') as 'Player',

SUM(CASE WHEN Months = 'July' THEN 1 ELSE null END) AS...

thanks for you replay Jeff i checked out that best practices article and have generated the following code to create the necessary table and insert the data thanks for the...

thanks for your reply upendramkumar i have uploaded a pic of the results i am hopig to get you can view it here

Tim

if i remove the date from the group by leaving this sql

Select p.Id as 'playerId',

IsNull(p.firstName+ ' ','') + IsNull(p.MiddleName+ ' ','') + IsNull(p.LastName,'') as 'Player',

Cast(Case when DATENAME(MONTH, tl.Date) =...

Thanks a million man, that had been driving me crazy for while now

Cheers

Tim

thanks alot for your help i managed to get it working

Tim

sorry no those are the results i have displaying at the moment, i have a count for each club but now i need to group the clubs by league and...

thanks for your reply but do u know if there is some way i can group the columns because the results from my query are like this

Mon ...

Hi,

Thanks for your replies guys i managed to put some pieces of code together and get what i needed

SELECT Distinct Substring(DATENAME(MONTH, SeqDate), 0, 4) as 'Month',

Month(SeqDate) as 'MonthID',

CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(SeqDate)-1),SeqDate), 103)...

Hi,

Thanks for your reply, i think i am 90% there but when i try to introduce my dates to the query i get the following error

'StartDate' is not a...

ok i have got this working but it is very slow so i will check out the other options u suggested and see if i can find something faster

Thanks...