“Arithmetic overflow error converting numeric to data type numeric.” I received the following error and the query was terminated: Today I learned that if you get this error, it is probably because you did something weird with your precision and scale parameters while defining a numeric datatype.ĮG – the following portion of a select statement was used to determine patient age at service:ĬAST(( DATEDIFF( d, PT.DOB, CASE.DOS)/ 365.25) AS numeric( 3,1)) AS PtAge ORDER BY #EncList.PAT_MRN_ID, #EncList.SURG_DT IF OBJECT_ID( ‘tempdb.#EncListCPTMatches’) IS NOT NULL DROP TABLE #EncListCPTMatches ĪND PAT_SURG.SURG_DATE = #Enclist.SURG_DTĪND Proc_CPT.CPT_CODE IN ( /*Approved CPTs*/ ‘32220’, ‘32662’, ‘32674’, ‘33020’) Without further ado, this is my query that makes “CPT” the default string inside the “PROC_CODE_TYPE” field:
So I tried something simple and intuitive (and probably well-documented if not for my weak google-fu) – and it appears to work. Alternatively, creating the table without that column and then adding it after the fact. I did a little googling and the answers I found seemed to be overly complicated for what I needed: Basically making a blank column, and then updating it.
#SQL SERVER EXPRESS ADVENTUREWORKS DATABASE 2016 CODE#
In preparation to performing a Union query between a table of procedures using CPT codes and a table of procedures using ICD-9 codes, I want my field names to match, but for a field called “PROC_CODE” to identify which code is which type once the two tables are combined.
0 kommentar(er)
