|
|
Posted by Connie on 04/11/07 19:09
On Apr 10, 4:46 pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
> "Erland Sommarskog" <esq...@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 Ratchevhttp://www.SQLStudio.com
Thanks everyone.......your all awesome, Yes Erland I did try the
first option, but I did not try with the bigint.....I was looking at
it too long and getting frustrated I guess, but thanks again everyone,
Navigation:
[Reply to this message]
|