Thanks. ________________________________
Kimden: [email protected] bu kiþinin yerine: rajesh kotian Gönderilmiþ: Per 15.09.2005 08:38 Kime: [email protected] Konu: Re: [development-axapta] [Urgent] Run SQL from Query Analyzer Dear Cenk, I dont think so updating it through Query anlyser would be a harmful for data. As i had tried many updation on tables using Query anlyser thanks On 9/14/05, Cenk Ince <[EMAIL PROTECTED]> wrote: > > Hy All > > I have made some modifications on inventTransid field on inventTrans. Now > i want to update InventSettlement and i want to run code form Query > Analyzer(Because it's Time saving.). > > Do you think it's harmful for data? > > Thanks. > > > > Update bmssa.INVENTSETTLEMENT Set > bmssa.INVENTSETTLEMENT.InventTransId = bmssa.INVENTTRANS.InventTransId > from bmssa.INVENTSETTLEMENT WITH(INDEX(I_173RECIDTYPEIDX)), > bmssa.INVENTTRANS WITH(INDEX(I_177RECID)) > Where bmssa.INVENTTRANS.TransRecID = bmssa.INVENTSETTLEMENT.recId AND > bmssa.INVENTTRANS.InventTransId <> bmssa.INVENTSETTLEMENT.InventTransIdAND > bmssa.INVENTTRANS.dataAreaId = 'SPK' AND bmssa.INVENTSETTLEMENT.dataareaID= > 'SPK' > > > > > [Non-text portions of this message have been removed] > > > > > > > > Yahoo! Groups Links > > > > > > > [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
