Thank you Mr Gail for your efforts and suggestions.

But I am aware of DBCC TRACEON(1204,1807) Flags for monitoring and resolving deadlock.

Is there any thing apart from this that has to...

Resposted my reqirements once again.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=396336

Thanks for everybodys effort.

I modified this part:

cast(convert(decimal(16,0),userenteredvalue) as varchar(200)) and the query gave me the correct result

Satish