Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
ElevateDb SQL |
Sat, Mar 3 2007 11:26 AM | Permanent Link |
Hendrik Steyn | What is the equivalent of the following in ElevateDb
Update table1 set table1.field1=table2.fieldx from table1 on table1.fieldy=table2.fieldz where <condition> |
Mon, Mar 5 2007 9:25 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Hendrik,
<< What is the equivalent of the following in ElevateDb Update table1 set table1.field1=table2.fieldx from table1 on table1.fieldy=table2.fieldz where <condition> >> See here: http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=19&msg=1020&page=1#msg1020 Although I must point out that we may re-introduce the joins at some point. However, I don't have any firm dates for that at this time. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Mar 5 2007 10:48 AM | Permanent Link |
"Donat Hebert \(Worldsoft\)" | I would strongly support re-introduction of the join as the performance hit
for multi-column update with sub-selects is huge! For example, updating payroll master where you have 30-40 fields or financial GL or PayPeriod Distributions where again you have 13 and/or 27 fields. The previous syntax gives us excellent response and we need that advantage. Donat Hebert "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:1AF22D31-24CF-4FC8-A461-DD1D49898C0B@news.elevatesoft.com... > Hendrik, > > << What is the equivalent of the following in ElevateDb > > Update table1 > set table1.field1=table2.fieldx > from table1 > on table1.fieldy=table2.fieldz > where <condition> >> > > See here: > > http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=19&msg=1020&page=1#msg1020 > > Although I must point out that we may re-introduce the joins at some > point. However, I don't have any firm dates for that at this time. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > |
Mon, Mar 5 2007 3:25 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Donat,
<< I would strongly support re-introduction of the join as the performance hit for multi-column update with sub-selects is huge! For example, updating payroll master where you have 30-40 fields or financial GL or PayPeriod Distributions where again you have 13 and/or 27 fields. The previous syntax gives us excellent response and we need that advantage. >> You'll have to use multiple steps and/or SQL statements for now. I would suggest coding a stored procedure to do what you want using a driver cursor for updating the related rows as necessary. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Friday, May 3, 2024 at 06:06 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |