Archives of the TeradataForum

Message Posted: Tue, 01 Jul 2003 @ 19:37:59 GMT

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

Stacy:

Do you really need a stored procedure to return TRUE or FALSE?

What about something like this correlated subquery:

select * from infotable
WHERE EXISTS
(sel * from  as this_table
 WHERE infotable.lat=this_table.lat  and
       infotable.lon=this_table.lon and
        this_table.othercolumn=10);

You could then put it into a macro to pass the longitude and latitude values as well as any other values you decide are appropriate.

Regards,

Mike

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