[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
RE: Re: UKHA Classified update - SQL Help!
- To: "'ukha_d@xxxxxxx'" <ukha_d@xxxxxxx>
- Subject: RE: Re: UKHA Classified update - SQL Help!
- From: "BUTLER, Tony, FM" <tony.butler@xxxxxxx>
- Date: Thu, 28 Mar 2002 09:09:30 -0000
- Delivered-to: mailing list ukha_d@xxxxxxx
- Mailing-list: list ukha_d@xxxxxxx; contact
ukha_d-owner@xxxxxxx
- Reply-to: ukha_d@xxxxxxx
> Graham
>
> Here is a procedure that will do the work you need:
<SNIP>
Certainly a lot shorter than my solution steve!
> There is a way to do it without a temporary table but it involves
> recursively calling the same procedure and gets very messy trying to
> dynamically allocate different cursor names on each entry to
> the stored
> proc.
Steve - you don't need to worry about renaimg the cursor. variable scope
does it's bit and the local cursor takes precedence over the calling proc's
cursor.
Tony
********************************************************************
Visit our Internet site at http://www.rbsmarkets.com
This e-mail is intended only for the addressee named above.
As this e-mail may contain confidential or privileged information,
if you are not the named addressee, you are not authorised to
retain, read, copy or disseminate this message or any part of it.
********************************************************************
Home |
Main Index |
Thread Index
|