Posted by Plamen Ratchev on 04/10/07 21:46

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns990F2D6DACA2Yazorman@127.0.0.1...
>
> you don't say whether you tried this, but I can see that it will fail
> with integer overflow. Howeever this should work:
>
> SELECT SUM(cast(datalength(document) as bigint)) FROM plan_report
>

Good catch Erland! I didn't see the big number and the overflow...

Plamen Ratchev
http://www.SQLStudio.com

[Back to original message]