random error for CAST( MONEY AS VARCHAR) - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

random error for CAST( MONEY AS VARCHAR)

random error for CAST( MONEY AS VARCHAR)# Database - 数据库

f*s2010-10-21 07:10

1 楼

我明年秋天要到另外一所大学工作.　我在现在的大学已经工作了３年了,　I-140去年
六月拿到.　秋天要去的大学里的律师马上要帮我申请perm 和H1B,她要我给她现在所在
学校的I-140的复印件.　我还没敢去问是不是会给.　一般情况会给一份复印件吗?　他
们已经知道我要辞职.　会不会为难俺呀?　需不需要策略?
多谢!　再问问,　教职工转工作以后,　大学通常会Revoke I-140吗?

j*n2010-10-21 07:10

2 楼

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*a2010-10-21 07:10

3 楼

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.