note
roboticus
<p>[DanEllison]:</p>
<p>I'd try one of two things: Either tell the database to explicitly use a larger numeric datatype in the hope that the driver will handle it:</p>
<c>
select convert(numeric(15),count(*)) from ...
</c>
<p>or failing that, have the database convert it to a string:</p>
<c>
select convert(varchar(32),count(*)) from ...
</c>
<p>I've never used Teradata, so I don't know if the syntax would need tweaking, but I'd expect a trick like this to get you to your goal.</p>
<p>...[roboticus]</p>
<p><i>When your only tool is a hammer, all problems look like your thumb.</i></p>
1007766
1007766