15,672,220 members
Home / Discussions / Database

# Database

 Re: (Expiring Next Month) Problem Jassim Rahma11-Aug-14 23:40 Jassim Rahma 11-Aug-14 23:40
 Re: (Expiring Next Month) Problem GuyThiebaut12-Aug-14 1:42 GuyThiebaut 12-Aug-14 1:42
 Re: (Expiring Next Month) Problem Bernhard Hiller12-Aug-14 21:28 Bernhard Hiller 12-Aug-14 21:28
 Re: (Expiring Next Month) Problem GuyThiebaut12-Aug-14 21:45 GuyThiebaut 12-Aug-14 21:45
 Re: (Expiring Next Month) Problem GuyThiebaut11-Aug-14 22:07 GuyThiebaut 11-Aug-14 22:07
 T-Sql Distribute data into groups based on existing numbers dreaddan10111-Aug-14 10:42 dreaddan101 11-Aug-14 10:42
 Re: T-Sql Distribute data into groups based on existing numbers Jörgen Andersson13-Aug-14 22:44 Jörgen Andersson 13-Aug-14 22:44
 Problem with Decimal Places and Rounding off Vimalsoft(Pty) Ltd9-Aug-14 23:02 Vimalsoft(Pty) Ltd 9-Aug-14 23:02
 Good Day All i have a Following Query 1) Query 1 SQL ``` DECLARE @FINALVAUE VARCHAR(MAX) = (Convert(decimal,@CAUSATIVE_FACTORS_ID) - 1) + Convert(decimal,@LU_PERCENTAGE_FAILURE_IN_SAMPLE_ID) + Convert(decimal,@LU_REPORTING_HISTORY_ID) PRINT @FINALVAUE -- the answer is 3 ``` The Calculation is like this 2) Query 2 SQL ``` DECLARE @FINAL VARCHAR(MAX) SET @FINAL= (4-1) + 0.08 + 0.2 SELECT @FINAL -- the asnwer is 3.28 ``` The first Query i am retrieving values from the Variables which are varchar and converting to decimal and doing the calculations. and the second Query i am just taking the value as is. i used this to debug in trying to solve this problem. My problem here in the first Query in the @FINALVAUE variable the answer is "3" and in the second Query the answer is "3.28" , i want the first Query to display the same value which is "3.28" Thanks Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa[at]dotnetfunda.com http://www.Dotnetfunda.com
 Re: Problem with Decimal Places and Rounding off Kornfeld Eliyahu Peter10-Aug-14 0:00 Kornfeld Eliyahu Peter 10-Aug-14 0:00
 Re: Problem with Decimal Places and Rounding off Vimalsoft(Pty) Ltd10-Aug-14 1:28 Vimalsoft(Pty) Ltd 10-Aug-14 1:28
 Select and Update jkirkerx8-Aug-14 11:43 jkirkerx 8-Aug-14 11:43
 My none soup version jkirkerx8-Aug-14 12:11 jkirkerx 8-Aug-14 12:11
 Re: Select and Update PIEBALDconsult8-Aug-14 20:57 PIEBALDconsult 8-Aug-14 20:57
 [Solved] jkirkerx10-Aug-14 12:50 jkirkerx 10-Aug-14 12:50
 Re: Select and Update MeutherOlaf11-Aug-14 20:36 MeutherOlaf 11-Aug-14 20:36
 Weird problem with UNION query in Access 2010 Peter R. Fletcher8-Aug-14 3:46 Peter R. Fletcher 8-Aug-14 3:46
 Find the right SSMS Corporal Agarn8-Aug-14 1:53 Corporal Agarn 8-Aug-14 1:53
 Re: Find the right SSMS Richard Deeming8-Aug-14 2:18 Richard Deeming 8-Aug-14 2:18
 Re: Find the right SSMS Corporal Agarn8-Aug-14 2:25 Corporal Agarn 8-Aug-14 2:25
 sql server insert into select + in select part if else Karan_TN7-Aug-14 0:16 Karan_TN 7-Aug-14 0:16
 Re: sql server insert into select + in select part if else Mycroft Holmes7-Aug-14 0:55 Mycroft Holmes 7-Aug-14 0:55
 How to change multiple date formats in Sql server AzeeM_R6-Aug-14 2:51 AzeeM_R 6-Aug-14 2:51
 Re: How to change multiple date formats in Sql server Corporal Agarn6-Aug-14 3:38 Corporal Agarn 6-Aug-14 3:38
 Re: How to change multiple date formats in Sql server Richard Deeming6-Aug-14 3:50 Richard Deeming 6-Aug-14 3:50
 Re: How to change multiple date formats in Sql server Mycroft Holmes6-Aug-14 14:16 Mycroft Holmes 6-Aug-14 14:16
 Last Visit: 31-Dec-99 18:00     Last Update: 10-Jun-23 2:28 Refresh ᐊ Prev1...170171172173174175176177178179 Next ᐅ