Thanks a lot guys...All of the responses were helpful .

Okay .. Will try that and let you know ..

Can you guide me in what way can the date fit in .. Should we be moving data to diff...

If you just insert the below records into temp1 and run your query its not ranking as expected for the Cn0--15 .. I believe the other query which I made...

Thanks a lot in advance for the help..

The part I don't understand is just the count(T1.Cid) = 1 ( why 1 )...I did understand rest of the query and was...

I really did not understand the query why you have Count(T1.CID) = 1 then T.CID in the order by clause.. I have rewritten the code to below by changing the...

Lets insert few more records into the #temp1 table in addition to the existing one..

INSERT INTO #temp1

SELECT 11,1,'2013-07-17 15:33:40.043'

UNION

SELECT 11,1,'2013-07-27 15:33:40.043'

UNION

SELECT 11,1,'2013-08-05 15:33:40.043'

UNION

SELECT 11,2,'2013-07-30 15:34:03.857'

UNION

SELECT 15,2,'2013-06-03 15:34:03.857'

UNION...

Firstly Thanks a lot for the response ..

Like I mentioned I need to check the records created only in the last 30 days and find out the max count for...

Thanks Guys for the response.. But just want to know if there is a workaround for this issue using crossapply ?

AS it is looping through all the records now ..

Sure , I wil have a look ..

once again thanks ..

Thanks Dwain..Tat was simple.

I thought i was good at writing SQL queries but not anymore ..I guess i was much of thinking on how to acheive the result set using...

Hi,

If you can explain it a bit more with expected data it would be really helpful to answer your question ..

Thanks.. Will try and let you know ..

Yes it is linked .. So when i browse the cube i am able to get that .. but how do i get it using MDX query so that i...

Thanks Ray .. I used switch function..

Can you explain me a bit more..

This is my req ,sorry if i havent explained correclty in first instance. need to create a dashboard where i have

X- axis...