Archives of the TeradataForum

Message Posted: Thu, 17 Jul 2003 @ 19:58:17 GMT

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

That's why I suggested....

sel * from pdata.item_master sample 1;
.if activitycount = 0 then .quit 8

This will give the results that are being looked for.

Rob Bankston
Teradata Certified Professional
UnumProvident - Data Warehouse

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