Good Morning!

Hmmm. Good point. I had missed that. I would have
figured it out when I got the singleton select error
message.

However, even with the For Select..., I am still
getting the same pesky error message.

Any other ideas?

Thanks...Dan'l


--- Svein Erling Tysvaer
<svein.erling.tysvaer@...> wrote:

> Seems like you should use FOR SELECT (can return
> multiple rows, often used
> with SUSPEND) and not just SELECT (must return a
> single row when used in a SP).
>
> Set
>
> Create Procedure sp_Invoice_Labor
> >(ServiceOrderId Integer)
> >Returns
> >(
> >...
> >)
> >As
> >Begin
> > SELECT ...
> > FROM LABORDETAIL A
> > JOIN CLIENTEQUIPMENT B ON
> >A.CLIENTEQUIPMENTID=B.CLIENTEQUIPMENTID
> > WHERE A.SERVICEORDERID=:SERVICEORDERID
> > Into ...;
> > Suspend;
> >End /* Procedure sp_Invoice_Labor */
>
>

=====
____________________________________
Every day is a Great day, but
some days are GREATER than others!

__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com