converting to numeric (6,3)

Transact-SQL

Index ‹ SQL Server

- Previous
  - 1
    - Problem in Installing SQL Server 2000 Personal Deepak... you can install Personal Edition on XP as well.. the problem seems to be something else... check error log or post the exact error what u get BTW why u want to install 2000 , you have SQL Server 2005 Express downloadable edition. I think u should install that... http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx http://www.databasejournal.com/features/mssql/article.php/1442281 Madhu Tag: converting to numeric (6,3)
  - 2
    - Deployment problem Help Hello all experts, I have tried to deploy my cube using an XML Script in dev box, modify connecting string by changing server name, run in QA box, and process cube, but always failed. Error massage: ‘Process failed. Trace information is still being transferred. If you do not want to wait for all of the information to arrive press Stop.’ Any one had experience for this error Thanks in advance. Tag: converting to numeric (6,3)
  - 3
    - Reporting Services printer problem I am using a web service that is running on a Windows 2000 server on local area network alongwith a printer, as such there is no error. Tag: converting to numeric (6,3)
  - 4
    - Month/Year comparison against a date WHERE ( ReportDate > dateadd( month, datediff( month, 0, @StartDate ) , -1 ) AND ReportDate < dateadd( month, datediff( month, 0, @EndDate ) + 1,0 ) ) I just edited the previous reply to make it more close to your requirement.. Tag: converting to numeric (6,3)
  - 5
    - VB6 RDO error Hello Below is the vb6 code that is used (it hasn't been changed and works for sequel 6.5): Dim qryStoredProc As rdoQuery Set qryStoredProc = New rdoQuery qryStoredProc.QueryTimeout = m_Cn.QueryTimeout qryStoredProc.SQL = "{ = call " & StoredProcedure & " }" Set qryStoredProc.ActiveConnection = m_Cn 'app falls over on the line below ..... qryStoredProc(0).Direction = rdParamReturnValue qryStoredProc.Execute Below is the definition of the store proc: ALTER Procedure [dbo] . [FraudCaseExists] @CaseID varchar ( 13 ) As DECLARE @Cases int IF @CaseID = 'ZZZ9999999999' SELECT @Cases = 0 ELSE SELECT @Cases = COUNT ( FraudCaseID ) FROM Cases WHERE FraudCaseID = @CaseID return ( @Cases ) Thanks, any pointers would be appreciated ! Tag: converting to numeric (6,3)
  - 6
    - Transaction Question Thanks. That did it. We use the double quotes in our code so that the string that EXEC executes can have single quotes. It is neccessary for the type of scripts we write. Doubling up the single quotes does not work in the way we do it. JD Waleska, GA Tag: converting to numeric (6,3)
  - 7
    - Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4 Hi ErikEJ, Thanks for the infor. I'm sure the SP4 is there because the SQL Server Enterprise Manager show me "8.00.2039(SP4)". The installer that i using right now is come from the link you mentioned. Best regards, Plane Tag: converting to numeric (6,3)
  - 8
    - Integrating SSRS with report viewer Thanks Scott Can you explain lil bit more in details Thanks Tag: converting to numeric (6,3)
  - 9
    - successful implementation of dataware house and data mining Hi! Have a look at Project Real here: http://www.microsoft.com/technet/prodtechnol/sql/2005/projreal.mspx HTH Thomas Ivarsson Tag: converting to numeric (6,3)
  - 10
    - Aggregation wizard Sully, This is definately possible. First off, as mentioned, make sure you have refreshed your DSV. Second, the aggregation wizard counting is broken....kind of. If you have numbers already, it will not update them. So, as a quick fix, delete the numbers and click count. It should go back and fill them in correctly assuming your DSV is refreshed. Also, if you don't want to go through and delete each and every one of them from the design wizard, there is a tool on code plex called BIDS Helper that will do it for you (among other great things that it does). You can download it here: http://www.codeplex.com/bidshelper There is a piece that will update the estimated counts. However, this can take a long time depending on the size of your dimensions. Hope this helps! -Brian Tag: converting to numeric (6,3)
  - 11
    - USING SSIS for scheduled import Tag: converting to numeric (6,3)
  - 12
    - Monitor network resources used by single database Hi, Is there any methord to monitor network utilization per database on single instance of SQLServer2005 or SQLServer2000. Please help Regards Mohd Sufian Tag: converting to numeric (6,3)
  - 13
    - Drop database on a different SQL Server. Thanks for the reply! i can do that but my problem is different. I am deleting database from my application which calls a VB component to delete the database. SP is called from this VB component and this SP resides on Admin DB which is on , say server1. database that has to be deleted is on a different server running a different SQL Server instance. Is this thing possible in any way Waiting for your reply. Tag: converting to numeric (6,3)
  - 14
    - replicating UDT's to subscribers in the article properties i left it on false for replicate user defined data types. it's UDT on the publisher and the base types on the subscribers. Tag: converting to numeric (6,3)
  - 15
    - XQUERY / XPATH versus nodes containing ":"-character Thank you so much! That did it! Tag: converting to numeric (6,3)
  - 16
    - SQL Server vs. XML Configurations Thanks Phil for your reply, I do have SQL Server configurations and only one configuration defined. Also they all have a different GUID. The main thing i notice is that the package will not even make the connection to the server. I receive this error message upon executing: Error: 0xC00291EC at Execute SQL Task, Execute SQL Task: Failed to acquire connection "servername". Connection may not be configured correctly or you may not have the right permissions on this connection. Task failed: Execute SQL Task This also happens when i create the xml configurations until i go into the file and insert the password in the password property. Inserting the password in the password property does not fix the problem with the SQL Server configuration. The problem is fixed however when I insert he pwd=password into the connectionstring, but I would like to avoid inserting that directly into the connection string. I have no idea what to do from here, Sam Tag: converting to numeric (6,3)
- Next
  - 1
    - Datasource Views and Teradata I'm trying to to use SSAS 05 w/ our Teradata warehouse (VERSION 05.01.02.70 RELEASE V2R.05.01.02.40) and I'm having a problem creating datasource views. My issue is that the wizard returns every view and table in the warehouse (tens of thousands) which takes over 10 minutes . I can't seem to limit it to only the database I'm intersted in using. I've tried using the restrict schema option but then no objects are returned. Any ideas on how to do this Can you create the datasource views without the wizard Thanks. Tag: converting to numeric (6,3)
  - 2
    - Understanding code created by SSIS import/export Wizard I actually built the package in Business Intelligence Development Studio through the Project - SSIS Import/Export Wizard. The resulting 2 packages seem to have 2 xml files behind the gui code when I use the view code on the .dtsx files. These files though don't contain any information on the tables that I am exporting though. I'm trying to find out where I can find more details on the format of these files and where I can change the settings such as allow identify insert and delete rows or append data. Tag: converting to numeric (6,3)
  - 3
    - SQL Server 2005 Service Pack 2 - RTM - WHEN??? Hi, Does anybody know how many CTPs will be provided before the RTM will be delivered Thanks Tag: converting to numeric (6,3)
  - 4
    - Parameterized Queries Thanks ErikEJ That explains everything. It also solves my second problem with output parameters. If you cant have multiple queries then Output Parameters wouldnt be very useful either. Thank you again. David Tag: converting to numeric (6,3)
  - 5
    - Users and Roles script In 2005, is there a way to automate this I'd like to be able to do this automatically periodically: 1) Script out the development users and their roles in my development database 2) Backup the production database and restore the it to the development database 3) Re-synch the existing users (sp_change_users_login), drop any obsolete users (sp_dropuser), and add any development users with roles back on Does anyone have a script that can help me achieve this Tag: converting to numeric (6,3)
  - 6
    - how to extract this text? Here's a similar approach: Chris DECLARE @numbers TABLE ( Number INT NOT NULL PRIMARY KEY ) INSERT INTO @numbers SELECT ROW_NUMBER () OVER ( ORDER BY s1 . [object_id] ) FROM master.sys.objects s1 CROSS JOIN master.sys.objects s2 DECLARE @Input TABLE ( [ID] INT NOT NULL IDENTITY PRIMARY KEY , [String] VARCHAR ( 150 ) ) INSERT INTO @Input ( [String] ) SELECT 'DT·NB·NM·ANI=8008808039139662' UNION SELECT 'ANI=8008808036637576·DNIS=80088080·DT·NB·NM·UNIT' UNION SELECT 'ANI=8008808039188390·ANI=8008808017403125·DNIS=80088080·DT·NB·NM·UNIT' UNION SELECT 'ANI=8008808039653135·ALIAS·DNIS=80088080·DT·NB·NM·UNIT' UNION SELECT 'ALIAS·ANI=8008808039169467·ANI=8008808017326875·UNIT·NM·NB·DT·DNIS=80088080' UNION SELECT 'DT·NB·NM·DNIS=80088080·ANI=8008808036331200·ANI=8008808039318646' DECLARE @Output TABLE ( [ID] INT NOT NULL, [XPOS] INT NOT NULL, [String] VARCHAR ( 8 ) NOT NULL ) INSERT INTO @Output ( [ID] , [XPOS] , [String] ) SELECT i . [ID] , n . Number , CASE WHEN SUBSTRING ( i . String , n . Number , 14 ) LIKE 'ANI=800880803[6 OR 9]' THEN SUBSTRING ( i . String , n . Number + 12 , 8 ) END AS [Output] FROM @Input i CROSS JOIN @Numbers n WHERE CASE WHEN SUBSTRING ( i . String , n . Number , 14 ) LIKE 'ANI=800880803[6 OR 9]' THEN SUBSTRING ( i . String , n . Number + 12 , 8 ) END IS NOT NULL SELECT o2 . [ID] , REPLACE (( SELECT o1 . String AS [data()] FROM @Output o1 WHERE o1 . [ID] = o2 . [ID] ORDER BY o1 . [id] , o1 . XPOS FOR XML PATH ( '' )), ' ' , ' - ' ) AS String FROM ( SELECT DISTINCT [ID] FROM @Output ) o2 ORDER BY o2 . [ID] Tag: converting to numeric (6,3)
  - 7
    - Differences in varchar size usage, declaring the maximum available of 8000 characters Hi Marcel, Thanks for the answer, will help me much in designing table. So, about the variables, from your answer, you mean the system would not allocate enough space in memory according to the declared size What I mean is, the storage space in memory will keep growing as the string length changes, or maybe it is actually creating a new string altogether in a new memory space; rather than allocating a large enough space earlier In this case, if the memory space is kept enlarging, or allocating a new space, due to some string intensive operation in the defined procedure/function, would it affect the performance, as the developer can't get to define the maximum probable size, which he knows/can assume thanks a million Eugene Tag: converting to numeric (6,3)
  - 8
    - Daylight Saving Time DST 2007 Problems The windows gui gives me the right time. A cmd shell "time/t" command gives me the right time, but the T-SQL I quoted gets the wrong time and all my agent jobs are running an hour late, so something is up here... Tag: converting to numeric (6,3)
  - 9
    - end conversation : security context could not be retrieved Hi I did trace with audit broker conversation, there is this event after it, but there are not error message I recently ungraded to sp3, could this be a problem thanks Paul Tag: converting to numeric (6,3)
  - 10
    - Unicode causes Dimension build failure? Can you check to see whether the collation of your Analysis Services instance matches the collation of the underlying SQL Server database (assuming you're using SQL Server) I've seen similar errors in cases where they're different. Chris Tag: converting to numeric (6,3)
  - 11
    - Change member properties order in excel 2007 pivot table Hi! Try the Excel 2007 newsgroup. BR Thomas Ivarsson Tag: converting to numeric (6,3)
  - 12
    - SQL Server 2005 Limitation: Having many attributes for Neural Network Logistic Regression cannot handle nested table predictions either. Do all the attributes have to be predictable Tag: converting to numeric (6,3)
  - 13
    - readonly custom property I need to generate the value for a custom property internally and make it visible to developers, but I don't want them to modify it to ensure the data flow works correctly. Hope we'll have a way to do that in the future. Tag: converting to numeric (6,3)
  - 14
    - Label in parameter Thanks for quick answer! Yes it's query driven. I'll try to do as you wrote. //C Tag: converting to numeric (6,3)
  - 15
    - SSIS performance Hi Phil, I am using SP2. Yes, I am passing variables from parent to child packages. Inserting data takes very less time. But Post Execute is taking lot of time, major chunk of time is gone in this only. Thanks, Vipul Tag: converting to numeric (6,3)
  - 16
    - - - Tag: converting to numeric (6,3)

sl0140

Hey guys,

I am trying to achive the following:

Truncate the values 1680.390000000000000000

to numeric (6,3)

All works ok until i hit a value over 1000, (as above)

The code i was using is:

cos1 = 1680.390000000000000000000

CONVERT (NUMERIC(6 , 3), ROUND(COS1, 3))

I have tried a few others, but nothing seems to work..

I get the following error. "Arithmatic Overflow"

Has anyone got any suggestions

Thanks guys,

Scotty

Re: converting to numeric (6,3)

Arnie Rowland

A numeric(6,3) would only accept a number as large as 999.999 -six digits total, three digits to the right of the decimal.

Your value, 1680.xxxx exceeds the maximum size and creates an overflow condition -resulting in an error.

Perhaps you need a larger number, like maybe, just guessing here, numeric(8,3)

Re: converting to numeric (6,3)

sl0140

Brilliant!!!!

thanks vry much Archie.. this has been confusing me all day,, the way they explain it looks to me as 6 to the left, and 3 to the right...

Thanks again

Scotty