var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Round problem
I am using sql statement to save data in SQL SERVER but even i did not apply any round function it is automatically rounding up. e.g. 3.56 when i see it in database it is 4 how can i avoid this rounding? I am using MS Access as front end.
Any help will be highly appreciated.
What's the datatype in sql server?
Can you post the DDL of the table?
It'll need to be something like
decimal(15,2), float or real, numeric, money or smallmoney
I would use decimal
Did you ever fix your trigger?
Damn another fluff post...
Here is table. Regarding Trigger , I could not solve it. Can you help me regarding that too?
CREATE TABLE [dbo].[VALID_ITEM] (
[DB_CONTRACT] [decimal](10, 0) NOT NULL ,
[PC_CODE] [int] NOT NULL ,
[ITEM_NO] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[NEW_ITEM] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DESCPT] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UNITS] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TYPE_ITEM] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[RET_PERC] [decimal](3, 0) NULL ,
[PROJQ] [decimal](11, 3) NULL ,
[CONTQ] [decimal](11, 3) NULL ,
[QTD] [decimal](11, 3) NULL ,
[TAMT_RET_ITEM] [decimal](12, 2) NULL ,
[TAMT_PAID_ITEM] [decimal](12, 2) NULL ,
[CONTR_PRICE] [decimal](12, 3) NULL ,
[IND_OVR_UND] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
Which column is rounding...but looks like you need precision...
gotta split...I'll check it in the am
Damn...another fluff post on my part
The column [QTD] [decimal](11, 3) NULL is giving problem.
You may want to look at how you are saving the data to the table. If you have access to Profiler you may want to run the SQLProfilerTSQL.tdf template and check the SQL statement passed to SQL Server. Chances are that access is rounding the value before passing it to SQL Server.
I checked on MS Access side, access is not rounding it. I have profiler how can i run SQLProfilerTSQL.tdf ?
Problem still there
any one help me about my problem?
Post your SQL procedure code.
Here is the portion which is giving the problem
set @var_vendor = (select gen_contr from ae_contract where db_contract=@var_db_contract)
set used_amt = isnull(used_amt,0) + @var_amt_result + @var_amt_ret_result where db_vendor = @var_vendor
This portion is doing the rounding. The value that is being rounded should have a data type of decimal with precision.
Also if you open Profiler, there is a list of templates that can show you the activity being sent to the SQL Server.
Thank you very much..it worked...