sql - Stored Procedure Update no Common Field Table -

-

i have 2 tables, table a has order no, order line, receiving no, receiving date, receiving qty.

order order line receiving no  receiving date  receiving qty      1         455555        12/01/2013       10      1         455556        12/01/2013       15      1         455557        15/01/2013       7      1         455558        16/01/2013       10      1         455559        16/01/2013       10      1         455560        16/01/2013       15      1         455561        31/01/2013       7

table b has order no, order line, invoice no, invoice qty, invoice date.

order order line invoice no  invoice date   invoice qty       1          333331      13/01/2013      32     1          333332      15/01/2013      10     1          333333      01/02/2013      32

how create stored procedure update invoice no, invoice qty , invoice date table b table a?

i'm new stored procedure, appreciated.

desired output :

order order line receiving no  receiving date  receiving qty  invoice no  invoice date    invoice qty       1         455555        12/01/2013       10            333331         13/01/2013     10       1         455556        12/01/2013       15            333331         13/01/2013     15       1         455557        15/01/2013       7             333331         13/01/2013     7       1         455558        16/01/2013       10            333332         15/01/2013     10       1         455559        16/01/2013       10            333333         01/02/2013     10       1         455560        16/01/2013       15            333333         01/02/2013     15       1         455561        31/01/2013       7             333333         01/02/2013     7

write query in stored procedure

update tablea set ta.recievingno = tb.invoiceno,     ta.recievingdate = tb.invoicedate     ta.recievingqty = tb.invoiceqty tablea ta inner join tableb tb    on ta.order = tb.order , ta.orderline=tb.orderline

Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

python - pip wont install .WHL files -

-
when try install .whl gohike typing cmd c:\users\owner\downloads>pip install ta_lib-0.4.9-cp27-none-win_amd64.whl i print out: `processing c:\users\owner\downloads\ta_lib-0.4.9-cp27-none-win_amd64.whl complete output command python setup.py egg_info: traceback <most recent call last>: file "<string>", line 1, in <module> ioerror: [errno 2] no such file or directory:'c:\\users\\owner\\appdata\\lo cal\\temp\\pip-9gwk2c-build\\setup.py' ----------------------------------------- command "python setup.py egg_info" failed error code 1 in c:\users\owner\ap pdata\local\temp\pip-9gwk2c-build\` the part between pip- , -build in pip-9gwk2c-build different on same file. i asked python 2.7.11 pip 8.0.3 can't install gohike whl of ta-lib 0.4.9 few days ago , decided ask differently. can me! you have outdated pip not understand wheels. wheels not supposed have setup.py inside. try upgrading pip pip in...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more