Archives of the TeradataForum

Message Posted: Thu, 05 Aug 2010 @ 13:17:00 GMT

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

The problem was due to the first column (which was the primary index) in the table being a member lapsed flag (containing 'y' or 'n'). Changing the primary index to a more distinct field (member number) has resolved this issue.

Thanks Dave for your help and code, which will be useful for future issue checking.

Thanks to all for your input.

Regards

Paul

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