This might sound odd but hopefully someone can shed some light on this.

I have a stored procedure thatr has three SELECT statements that are UNION'ed.

NOW it turns out the business users don't like seeing the multipole rows and just need the very first row in the cursor. For reasons I can't getinto, the UNIONS must stay (i hate my life).

Is there any way to just FETCH the first row of a CURSOR. For example:

DECLARE BONEHEAD CURSOR FOR SELECT
......
......
......

OPEN BONEHEAD CURSOR <would like to just select the first row here>

Thanks in advance!!

I am not sure that this will work, but you could try:

DECLARE BONEHEAD CURSOR for SELECT .... FETCH FIRST 1 ROW ONLY;

...


OPEN BONEHEAD;

Andy

I am not sure that this will work, but you could try:

DECLARE BONEHEAD CURSOR for SELECT .... FETCH FIRST 1 ROW ONLY;

...


OPEN BONEHEAD;


(I think my first post got messed up)

Andy

Tried putting the FETCH FIRST 1 ROW ONLY thing into each of the separate SELECT STATEMENTS. Would still end up returning three rows to the calling application...

Got it....!!

Was putting FETCH FIRST after each SELECT. Needs to go after all of them....

Thanks AR