Archives of the TeradataForum

Message Posted: Wed, 05 Jan 2005 @ 10:48:10 GMT

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

Hi,

Consider the below pseudo code for a macro.

Create macro m1(start_dt) as

     sel * from t1 where t1.dt= :start_dt;

I need this macro to select all rows when I pass NULL for the start date.

Any thoughts?

Thanks, Vivek

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