Archives of the TeradataForum

Message Posted: Wed, 30 Jul 2003 @ 08:51:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Cheryl,

The Bus Objs query involved generates relatively complex SQL - lots of brackets, a UNION statement, goes over several pages when pasted into Queryman etc. When run using ODBC 3.02.00.02 we got a spurious week 0 and lots of wrong figures in the This Year column for weeks that hadn't occurred yet. Upgrading to 3.02.00.06 fixed the problem.

Regards,

Gary

	<Prev	Next>		<<First	<Prev	Next>	Last>>