由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - random error for CAST( MONEY AS VARCHAR)
相关主题
SQL find distinct values in large tableBulk merge? (转载)
用SSIS EXPORT 到 EXCEL 2010 有2000个COLUMN,可能吗Rookie's question again
用SSIS传table从oracle到mssql,遇到一个奇怪的问题多对多relation?
一个关于T-SQL的问题Join optimization
请问sql server里面怎么输出变量到文本文件?How to replace 0 with empty?
做DW的,如何估计/衡量一项任务的工作量?error file或者exception file
SSIS package upgrade issueSQL query 一问
MSSQL Power FunctionSQL Server 2008 Exp 怎么export DBF file?
相关话题的讨论汇总
话题: money话题: varchar话题: cast话题: col话题: random
进入Database版参与讨论
1 (共1页)
j*****n
发帖数: 1781
1
MSSQL 2k5
Here is a table with about 400 columns, billions of rows; we have a view
does this:
SELECT .....,
CAST (col_n AS VARCHAR(11)) AS col_n, -- col_n is MONEY data type in the
table
...
FROM tbl
We have an SSIS ETL runs every day that pulling millions of rows based on
this view; it has been ran for couple years without problem.
Recently (started few weeks ago), we discovered that randomly this converted
col_n returns few 0's, no matter whatever the actual value is. say 20.12,
or -128.33, it returned '0'.
Anyone any idea? 50 baozi for answer... thanks!
i****a
发帖数: 36252
2
sounds strange.
can it be reproduced or does it only show up in the log/result after
your SSIS run?
would it be possible the source data is actually 0 when you run it?

view
the
on

【在 j*****n 的大作中提到】
: MSSQL 2k5
: Here is a table with about 400 columns, billions of rows; we have a view
: does this:
: SELECT .....,
: CAST (col_n AS VARCHAR(11)) AS col_n, -- col_n is MONEY data type in the
: table
: ...
: FROM tbl
: We have an SSIS ETL runs every day that pulling millions of rows based on
: this view; it has been ran for couple years without problem.

1 (共1页)
进入Database版参与讨论
相关主题
SQL Server 2008 Exp 怎么export DBF file?请问sql server里面怎么输出变量到文本文件?
career choices - Data warehouse/BI vs OLTP做DW的,如何估计/衡量一项任务的工作量?
pass parameter from stored procedure to SSISSSIS package upgrade issue
Statistician/Data Analyst Postion in Santa Monica (转载)MSSQL Power Function
SQL find distinct values in large tableBulk merge? (转载)
用SSIS EXPORT 到 EXCEL 2010 有2000个COLUMN,可能吗Rookie's question again
用SSIS传table从oracle到mssql,遇到一个奇怪的问题多对多relation?
一个关于T-SQL的问题Join optimization
相关话题的讨论汇总
话题: money话题: varchar话题: cast话题: col话题: random