Re: SQL Update query

From: Tom (Tom_at_discussions.microsoft.com)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 13:19:03 -0700

Hi Vishal,

You are right , tables mentioned belong to Siebel.

I ran sql update, but without any success. The message displayed as 0 rows
affected. To check with you do I need to paste the line begin transaction and
is there anything missing from my end.

Thanks
Tom

"Vishal Parkar" wrote:

> looks like siebel application tables :)
>
> anyway you can try following query.
>
>
> begin transaction
> UPDATE A
> SET FUL_CENTER_FLG = 'Y'
> FROM S_ORG_EXT A, EIM_ACCOUNT B
> WHERE B.LOC = A.LOC
> AND A.ROW_ID NOT IN
> (SELECT C.TARGET_OU_ID FROM S_EVT_ACT C)
>
> --check the data and commit / rollback accordingly
>
> --
> Vishal Parkar
> vgparkar@yahoo.co.in | vgparkar@hotmail.com
>
>
>