round off after decimal greater value

Posted by Bubaibanerjee under Sql Server on 8/28/2012 | Points: 10 | Views : 3360 | Status : [Member] | Replies : 2

i am using sql server 2008R2
my data is 123.21 2458
i want it 123.22
how can i do that in sql server query.please help me
thanks in advance

Reply | Reply with Attachment

Posted by: Saratvaddilli on: 8/28/2012 [Member] [MVP] Bronze | Points: 25

0	DECLARE @value float(6) SET @value = 123.21 2458 SELECT ROUND(@value, 2) Thanks and Regards V.SaratChand Show difficulties that how difficult you are Bubaibanerjee, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rambabu123 on: 8/28/2012 [Member] Starter | Points: 25

0	CAST(QTY_PACK AS NUMERIC(18,2))QTY_PACK, I think this is use for u Bubaibanerjee, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts