SEO

#1 (**permalink**) 04-08-2008, 06:17 PM

Hi all..

I need to change the following Select statement to an update statement
which updates hf.active to 'N' where all the hf.active found is 'n'.. I
am finding difficulties of re-writting this because of the recursive
relationship.

select
*
from
OrgUnit ou_sb inner join Allocation a
on ( a.subjectOrgUnitId = ou_sb.orgUnitId )
inner join OrgUnit ou_tb
on ( ou_tb.orgUnitId = a.parentOrgUnitId )
inner join HierarchyFlags hf
on ( hf.orgUnitId = ou_sb.orgUnitId )
where
ou_tb.orgUnitName = 'Old Books'
and hf.active ='n'

Many Thanks
Ali

#2 (**permalink**) 04-08-2008, 06:17 PM

What's your 'update' statement look like?

Is the 'update' statement generating an error (if so, what error), or is it
not functioning properly (ie, not updating the correct records)?

ali.alauoubiy@drkw.com wrote:

> Hi all..
>
> I need to change the following Select statement to an update statement
> which updates hf.active to 'N' where all the hf.active found is 'n'.. I
> am finding difficulties of re-writting this because of the recursive
> relationship.
>
> select
> *
> from
> OrgUnit ou_sb inner join Allocation a
> on ( a.subjectOrgUnitId = ou_sb.orgUnitId )
> inner join OrgUnit ou_tb
> on ( ou_tb.orgUnitId = a.parentOrgUnitId )
> inner join HierarchyFlags hf
> on ( hf.orgUnitId = ou_sb.orgUnitId )
> where
> ou_tb.orgUnitName = 'Old Books'
> and hf.active ='n'
>
> Many Thanks
> Ali
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Need Help with Sybase