sql server - Update column from another join column ,, -

-

first should easy db'es giving me pain here dont know why ,,

i have 2 tables , [table1] named applicationforms , [table2] named wfinstance need update formsubmitdate in table1 starteddate value in table 2 formsubmitdate null. write following query 

update    applicationform set              formsubmitdate = wfi.startdate         applicationform app ,                       workflowinstances wfi      app.formsubmitdate null , wfi.applicationid = app.id

when run query sql regenerate query one,, 

update    applicationform set              formsubmitdate = wfi.startdate         applicationform app inner join                       workflowinstances wfi on app.id = wfi.applicationid cross join                       applicationform     (app.formsubmitdate null)

i tried write statment using join ,, 

update applicationform set formsubmitdate = wfi.startdate applicationform  join workflowinstances wfi on applicationform.id = wfi.applicationid   formsubmitdate null

and sql generate same new syntax,,

now when run code , [all records] formsubmitdate fields filled first value of second table startdate. if have 1 record contains null value in table1

what missing here !?

i think want. try , let know.

update tabl3 set formsubmitdate=(select startdate   table4   table4.id=tabl3.id , tabl3.formsubmitdate null);

another way write same thing be

update tabl3 set formsubmitdate= startdate table4 tabl3.id = table4.id , formsubmitdate null

Comments

Post a Comment

Popular posts from this blog

javascript - Image onload event not firing in firefox -

-
i'm creating image preloader. works fine in browsers except firefox (testing firefox 10.0). input array of images called image_list . these images appended dynamically body of document , load callback attached, calls function update_progress . code follows: $(image_list).each(function() { var x = $('<img />') .load(function() {update_progress(percent_loaded += step);}) .attr('src', this) .appendto('body') .css('display', 'none'); .each(function() { if(this.complete) update_progress(percent_loaded += step); }); }); in firefox, load callback , update_progress never called. yet exact same code works fine in chrome , other browsers i've tested. there way detect when image has loaded in firefox? i first check see whether image has height, checking height property. if (the_image.height > 0) { // image loaded (possibly cached) } if have cached ...
Read more

android - getbluetoothservice() called with no bluetoothmanagercallback -

-
i getting getbluetoothservice() called no bluetoothmanagercallback error in android application. i have no idea causing or bluetooth manager callbacks. can give me idea of causing problem or start looking. by reading android source code, seems warning cannot about. source code shows if call bluetoothsocket#connect(); then call bluetoothadapter.getdefaultadapter().getbluetoothservice(null); the key here, null parameter passes in above line. due this, there no callback, , bluetoothsocket class throw out warning. since warning, not think need it. https://android.googlesource.com/platform/frameworks/base/+/master/core/java/android/bluetooth/bluetoothsocket.java line 306 https://android.googlesource.com/platform/frameworks/base/+/master/core/java/android/bluetooth/bluetoothadapter.java line 1610
Read more

sql - ASP.NET SqlDataSource, like on SelectCommand -

-
i'm working on asp.net. have sqldatasource query hardcoded on selectcommand: <asp:sqldatasource id="datasource1" runat="server" cancelselectonnullparameter="false" connectionstring="<%$ connectionstrings:s.properties.settings.connectionstring %>" selectcommand="select * [table] ([col1] case @col1_param when null col1 else @col1_param end) , ([col2] case @col2_param when null col2 else @col2_param end)" selectcommandtype="text"> <selectparameters> <asp:controlparameter controlid="textbox1" name="col1_param" propertyname="text" type="string" /> <asp:controlparameter controlid="textbox2" name="col2_param" propertyname="text" type="string" /> </selectparameters> what want if enter data on 1 textbox only, data display according textbox...
Read more