Thanks Thom and Roshan Joseph.
I tried all other functions to round off.
Atlast I got it.

SELECT cast(ROUND (300 /(CONVERT(decimal(10,5),54)),2) as numeric(36,2))


This query...

Hi,

We should not convert the number from 300 to 300.0 because I have dynamic number coming.

Regards,
Poornima

Thanks ChrisM.
This is more simpler and getting almost the same result

Thanks for helping ..
This is exactly what i want.
Thanks
DesNorton..

Hi,
Surely I will use CTE or Lookup table as suggested.
I will have a study about these two things and have a try.

Hi Thom,

I want to delete that one.But i don't find option.
After I read Jeff guide given by you, i understand how to give my entire table in...

Hi Thom,
I read Jeff's Guide to post code in an effective manner..
Thanks for your help.This really helped me to explain in a better way what my need is.

Hi,
I tested your query but I am getting the output as follows,

Type    Value
10        0
20        0
30        0

but My need...

Thanks DesNorton.
But never used indexing concepts it seems.
I hope...

Hi,

Using orderby also i never get the expected result.
Because from the resultened output i need to display only 129195 from number of occurences column..

Thanks,
Poornima

Hi,

I need to get the output from the resultened query.
Please try to achieve this.

Hi,
I need to achieve the above result using sub-query for the duplicating columns.

Hi Eirikur Eiriksson,

Thank you very much.

The Stored Procedure worked now.

Interested in learning these stored procedure and this forum is really helpful.

Tks for your immediate reply.:-)

Regards,

Poornima

Hi,

Thanks for your reply.

But I am getting the below error while executing the stored procedure.

Msg 487, Level 16, State 1, Procedure GetTop20MessageByRoomIdOrderByTimeStamp, Line 6

An invalid option was specified for the...