Posts

Showing posts from September, 2014

How to test android.intent.action.MY_PACKAGE_REPLACED -

i'd able test broadcastreceiver my_package_replaced. can accomplish adb command? does emulator accomplish when launch app ide (android studio)? am broadcast -a android.intent.action.my_package_replaced

wix - How to automatically uninstall DirectX 9? -

i putting wix installer includes silently installing directx 9: dxsetup.exe /silent how tell wix how un-install directx? there switch on command line? i need able configure installer un-install directx automatically, else users complain if can't uninstall. for directx end-user runtime (aka directsetup or dxsetup), has long been recommended don't try uninstall it. in case, on versions of windows can't 'uninstall' directx , running dxsetup doesn't "install directx" either it's built os. can updated installing new version of os, installing service pack, or applying windows update. applies versions of windows starting windows xp service pack 2, windows server 2003 service pack 1, , windows xp x64 edition. dxsetup still useful deploying stuff legacy d3dx9, d3dx10, d3dx11, xactengine, xaudio 2.7, xinput 1.3, d3dcompile #43 or earlier, etc. doesn't ever install "directx". see no direct setup . if after reading artic

sql - Finding the earliest date that a specific event occurred -

i trying find out whether user received coupon within 30 days of earliest date entered program. each user can potentially enter many programs, , trying mark earliest date program. example data: userid start_date programid coupon_date 1 2003-02-05 83435 2003-03-01 1 2004-05-04 83435 2005-03-05 1 2002-01-30 82222 2001-02-24 2 2001-02-02 82222 2001-04-22 2 2000-04-03 22222 2004-12-13 2 1999-02-05 83435 1999-05-02 2 2005-05-28 83435 2008-02-02 3 1998-01-01 24853 1999-02-02 3 2006-03-02 44533 2006-05-02 my desired output (for finding whether received coupon within 30 days of entering program 83435): userid start_date programid coupon_date match 1 2003-02-05 83435 2003-03-01 1 1 2004-05-04 83435 2005-03-05 0 1 2002-01-30 82222 2001-02-24 0 2 2001-02-02 82222 2001-04-22 0 2 2000-04-03 22222 2004-12-13 0 2

apache - DBD::Oracle, Cursors and Environment under mod_perl -

need help, because can't find solution problems dbd::oracle. so @ first, current situation: we running apache2 mod_perl 2.0.4 @ our company apache web server set startup script setting environment variables (ld_library_path, oracle_home, nls_lang) in httpd.conf there environment variables ld_library_path , oracle_home (via setenv) we using perl module dbi driver dbd::oracle connect our main database before create new instance of dbi setting perl env variables, (%env). setting oracle_home , nls_lang. so far, works fine. extending our system , need connect remote database. again, using dbi , dbd::oracle. there new conditions: new connection must run in parallel existing one tnsnames.ora new connection placed @ different location (not @ $oracle_home.'/network/admin') new database contents provided stored procedures, fetching dbd::oracle , cursors (like explained here: https://metacpan.org/pod/dbd::oracle#binding-cursors ) the stored procedures returning

java - Hibernate Exceptions: ClassCastException and QueryException -

i'm kind of new spring mvc bare me. want customer can profilepage. anchor needs click followed: <a href="${pagecontext.request.contextpath}/customer/profile/${pagecontext.request.userprincipal.name}"></a> and have following method in controller: @requestmapping(value = "/profile/{username}", method = requestmethod.get) public modelandview editprofileidpage(@pathvariable("username") string username) { modelandview customereditview = new modelandview("/customer/customerhome"); customereditview.addobject("customer", customerservice.getcustomerbyusername(username)); customereditview.addobject("title", "welkom"); return customereditview; } and next have user model , customer model. left out constructors , of getters , setters minimize code. user model @entity @table(name = "user", catalog = "...") public class user implements jav

javascript - Three.js camera rotation error -

firebug throwing error saying "three not defined" on var camera , cannot see why. error doesn't make sense me because see it; there defined 3 right on right hand of equals sign. init(); animate(); function init() { var camera = new three.perspectivecamera( 75, window.innerwidth / window.innerheight, 0.1, 1000 ); camera.position.z = 500; var controls = new three.trackballcontrols( camera ); controls.addeventlistener('change', render); var scene = new three.scene(); var geometry = new three.boxgeometry(100, 100, 100); var material = new three.meshbasicmaterial(); var mesh = new three.mesh( geometry, material ); scene.add(mesh); var renderer = new three.webglrenderer(); renderer.setsize(window.innerwidth, window.innerheight); document.body.appendchild( renderer.domelement );

file permissions - Specifying permisions with icacls -

i want allocate read permission "everyone" on empty folder users not allowed change folder name. want "everyone" able create/modify/delete files in folder. say folder called /fred/myfolder i've tried icacls /fred /grant everyone:(oi)r and icacls /fred/myfolder /grant everyone:(ci)r icacls /fred/myfolder /grant everyone:(oi)f and various combinations no avail. documentation/my knowledge isn't great. appreciated i found answer. needed icacls /fred /grant everyone:(oi)r then needed icacls /fred/myfolder /grant everyone:(oi)(ci)(oi)f these combinations found useful: (np) folder only. (oi) folder , files. (ci) folder , subfolders. (oi)(ci) folder, subfolders, , files. (oi)(ci)(io) subfolders , files only. (ci)(io) subfolders only. (oi)(io) files only.

regex - Ruby Regexp trouble. How to accept a string only if it doesnt have 'foo' -

i need regex accept this: "add chain=input comment="test" protocol=icmp blah blah other stuff" but not accept this: "add chain=input comment="test" blah blah disabled=yes so if @ end of string says disabled=yes, don't match it. i've tried this: (add action=drop chain=input .*(?!disabled=yes)) add action=drop chain=input [^disabled=yes] add action=drop chain=input.*[^(disabled=yes)] and couple other variations no avail. doing incorrectly? edit: def check( line, key ) return line[ key ] ? true : false end check( "add action=drop chain=input comment="test" disabled=yes", /add action=drop chain=input.*[^(disabled=yes)]/ ) this of code, broken down. use negative lookahead based regex below. ^(?!.*disabled=yes$)add(?: action=drop)? chain=input.* rubular (?!.*disabled=yes$) negative lookahead asserts there isn't string disabled=yes present @ last. , did make action=drop string optio

swift - Why do I have to pass arguments to classes in key-value form? -

class namedshape { var numberofsides: int = 0 var name: string init(name: string) { self.name = name } func simpledescription() -> string { return "a shape \(numberofsides) sides named \(name)" } } i have following example class. create new instance, do let shape = namedshape(name: "test") the arguments captured init() function, right? however, if this: let shape = namedshape("test") i missing argument label error! however, if define silly function this: func printint(numberin: int) { println(numberin) } i can invoke fine using: printint(5) however, if attempt invoke arguments formatted in way create class: printint(numberin: 5) i extraneous argument label error! help swift noob understand. why need label class arguments, can't label function arguments? why functions , classes different way? i'm sure there's i'm missing. because initializer functions are

c# - Azure Mobile Services Sync Context: Adding custom parameters -

i using azure mobile services provide data windows universal app , azure api management proxy api usage , analytics purposes. working great. now asked provide offline functionality application started using azure mobile services synchronization context in order implement using sqlite local store. azure api management requires me send subscription key part of query string. have been doing using 'parameters' dictionary provided imobileservicetable.insertasync method , working fine well. now offline implementation requires me use imobileservicesynctable.insertasync method instead, doesn't provide overload 'parameters' dictionary. mobileservicesynccontextextensions.pushasync method not seem provide way add custom parameters query string either. does know of way include custom parameters when using mobile services synchronization context in order send subscription key of azure api management service? i've found way this. i implemented follo

javascript - How to create binary blob from atob - currently getting different bytes -

i've got binary excel file created on server i'm returning c# webmethod using convert.tobase64string(filedata) called javascript/jquery $ajax call. i've confirmed base64 string data gets client, when attempt convert binary blob , save it, bytes saved disk aren't same on server. (i'm getting lots of 0xc3 etc. bytes, suspiciously utf8 double byte injections) $.ajax({ type: "post", contenttype: "application/json;", datatype: "json", processdata: false, data: "{ inputdata: \"" + datastring + "\" }", url: "api.aspx/getexcel", success: ... success handler code includes: var excelblob = new blob([atob(msg.d)], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;' }); ... var = document.createelement('a'); ... a.href = window.url.createobjecturl(excelblob); a.setattribute('download', 'excel.xlsx'); when complete

html - Remove h1 take from logo -

i'm trying remove heading tag logo , site title on website don't know how proceed. <header id="header" class="show-on-scroll" data-offset-el=".index-section" data-offset-behavior="bottom" role="banner"> <div class="header-inner"> {.section website}<div id="{.if logoimageurl}logowrapper{.or}sitetitlewrapper{.end}" class="wrapper" data-content-field="site-title"> {.section logoimageurl} <h1 id="logoimage"><a href="/"><img src="{logoimageurl}?format=1500w" alt="{sitetitle}" /></a></h1> {.or} <h1 id="sitetitle" class="site-title"><a href="/">{sitetitle}</a></h1> {.end} change h1 tag markup. <header id="header" class="show-on-scroll" data-offset-el=".inde

c++ - LinkedList using initializer_list -

so, i'm trying initialize linkedlist class using initializer_list. template<typename t> sortedlist<t>::sortedlist(initializer_list<t> e){ head_= new node<t>(*e.begin()); long intcheck = 0; t old; (auto x : e){ if(intcheck > 0){ node<t>* curr = new node<t>(old); if(head_ == curr){ head_->next_ = new node<t>(x); } curr->next_ = new node<t>(x); } old = x; intcheck = 1; } } i seg fault when trying print head_->next_ (nothing wrong print function) i'm assuming want sortedlist sorted. if so, accomplish goal. bails out if initializer_list empty, still leaves object in rational state. template<typename t> sortedlist<t>::sortedlist(initializer_list<t> e) : head_{nullptr} { if (e.size() == 0) return; auto = e.begin(); (head_ = new node<t>(*it);

java - How to use byte array convert to binary image( 0bits,1bits )? -

i want transfer bytearray binary image don't how it. array value have 0 , 1. 0 = black , 1 = white, byte [] arr = new byte[32*32]; for(int i=0;i<arr.length;i++){ arr[i]= i%2==0?(byte)0:(byte)1 } please me , thanks it depends on going binary image. if need computation, array may job better, although 2-dimensional array may more convenient use. if want construct bufferedimage object, can specify 1-bit per pixel type (see below), , fill content using setrgb() method. such image can saved file or shown in gui, or accessed getrgb() method. here working example (generatechecker.java): import java.awt.image.bufferedimage; import javax.imageio.imageio; import java.io.ioexception; import java.io.file; public class generatechecker { private static final int width = 32; private static final int height = 32; public static void main(string args[]) throws ioexception { bufferedimage im = new bufferedimage(32, 32, bufferedimage.type_byt

left join on same table in mysql -

i trying apply left join on same table not getting desired results. i have table table -- pages id name parent status 1 aaa 0 draft 2 bbb 1 live 3 ccc 13 live 4 ddd 0 live 5 eee 4 live 6 fff 4 live i want rows id status live , parent id's status live.so in above example id 2 should not appear it's parent id 1 status draft. i have made sqlfiddle -- http://www.sqlfiddle.com/#!2/d6b31/4 any highly welcomed. in advance. make sure fiddle's schema includes cases. cases provided did not include child not live without parent. this should expecting. select a.id, a.name, a.parent, a.status pages left join pages b on a.parent = b.id , b.status='live' a.status='live' , (b.status='live' or a.parent=0) adjusted cases: (1, 'aaa', '0', 'draft'), (2, &#

asp.net mvc - Add ID from URL in MVC -

im starting out mvc , i'm in learning phase. i'm stuck problem. in soulution got these 2 tables. topictable -topid -topname contenttable -contid -topid -content i want while i'm in topic detailes-view able create new content. in detailes.cshtml file i've added: @html.actionlink("create new content", "create", "content", new { id = model.topicid}, null)` display in url: localhost/content/create/1 in contentcontroller ive got this, , error when submitting " validation failed 1 or more entities. see 'entityvalidationerrors' property more details. " [httppost] [validateantiforgerytoken] public actionresult create(int id) { contentmodel content = new contentmodel(); if (modelstate.isvalid) { content.topid = id; db.contentmodel.add(content); db.savechanges(); return redirecttoacti

java - Updating the UI upon receiving an android push notification -

i have query regarding android push notification , had asked in stackoverflow post , did not out of [ query regarding android push notifications . posting again, , follows: i have android app receives push notifications google push notification service. when tap on received notification, opens ui displays message, list view. now, when user receives push notification, , assuming screen open, ui should refreshed automatically, such displays latest notification. let me know how can solve this? below code have implemented: java code receive notification: import java.util.timer; import java.util.timertask; import android.app.notification; import android.app.notificationmanager; import android.app.pendingintent; import android.content.context; import android.content.intent; import android.os.powermanager; import android.util.log; import com.example.foodu.r; import com.google.android.gcm.gcmbaseintentservice; public class gcmintentservice extends gcmbaseintentservice { pr

c++ - undefined symbols for architecture x86_64: "Shape::get_area()", referenced from: votable for shape in shape.o -

hi i'm pretty sure issue stupid cannot figure out life of me. have homework assignment meant reinforce have learned polymorphism in class (this c++ way). basis of program class called shape parent circle, triangle , rectangle. im getting linker error pure virtual method get_area() meant defined in child classes. can't life of me figure out why won't compile, haven't made main method make use of yet , prototype method shouldn't link right? anyway here code shape.h file: #ifndef assign8_shape_h #define assign8_shape_h #include <iostream> #include <stdio.h> #include <string> using namespace::std; class shape{ private: string color; public: shape(const string& n_color); virtual ~shape (); void print(); virtual double get_area() = 0; }; #endif and here shape.cpp file: #include <stdio.h> #include <string> #include "shape.h" using namespace::std; shape::shape(const string& n_color) {

regex - Jquery validate addMethod validate for custom method -

im using jquery validate , wish add method input text cannot contain ".com" im tried: //.com validator $.validator.addmethod('dotcom', function(value, element) { return this.optional(element) || (!value.match(/[.com]/) && value.match(/[.com]/)); }, dotcom); but doesn't work, suggestion ? thanks it looks regex test wrong. try var dotcom = 'value cannot contain `.com`' $.validator.addmethod('dotcom', function(value, element) { return this.optional(element) || !/\.com/.test(value); }, dotcom); $('form').validate({ rules: { site: { dotcom: true } } }) $('button').click(function() { $('form').valid(); return false; }) <script type="text/javascript" src="http://code.jquery.com/jquery-1.11.1.js"></script> <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/j

java - Issues re-starting a finish()ed android activity -

i have 2 android activities 1 single button on both. the activity detailsactivity main activity. public class detailsactivity extends activity { @override public void oncreate(bundle bundle) { super.oncreate(bundle); setcontentview(r.layout.details_activity_layout); } @override public void onresume() { super.onresume(); } public void gotosubdetails(view view) { intent intent = new intent(this, subdetailsactivity.class); startactivity(intent); finish(); } } and subdetailsactivity follows: public class subdetailsactivity extends activity { @override public void oncreate(bundle bundle) { super.oncreate(bundle); setcontentview(r.layout.sub_details_activity_layout); } @override public void onresume() { super.onresume(); } public void gotodetails(view view) { intent intent = new intent(this, detailsactivity.class);

can I use Jquery blockui(plugin) code withouut Ajax -

im newbie jquery please help...... i have 1 page has multiple links. when user click on 1 link before completes process backside , loads page, hitting links without wait causing issue. i'm looking solution avoid user hit multiple clicks @ time. to solve, have found jquery blockui plugin , downloaded (production version of) jquery.blockui.min.js link https://github.com/malsup/blockui/and added below code snippet $('#linkx').click(function() { $.blockui({ message: '<h1><img src="busy.gif" /> moment...</h1>' }); }); now when click on link (all links have same class name) code blocks page , display popup message "just moment", , once java process/request (default submit form action='/xxx') finishes (it process action , update database too) page refresh , automatically page unblocks. working fine. wonder using blockui feature correctly? can used without ajax, , regular java server (form action) request? is jq

ruby on rails - Nested Partials - Use Presenter Pattern? -

i have view getting unruly. i'd move more of view other partials result in nested partials...which wary of. i've heard of presenter pattern , implement here don't know how go it. row contain loop don't think can extract easily. advice appreciated! <div class="row"> <h2>applicant</h2> <%= render partial: 'people/summary', locals: { person: @applicant.identity } %> <%= link_to "edit", edit_person_path(@applicant.identity), class: "btn btn-info"%> </div> <%= render partial: 'divrow', locals: { var1: "household members" } %> <%= render partial: 'structure', locals: { path: "new_household_member_path" } %> <div class="row"> <h2>residence history</h2> <% @applicant.residences.each |r| %> <div class="col-md-4"> <p> <%= render partial: 'residences/summary',

How do I keep the javascript of my Phonegap application running minimized on android? -

developed application using android phonegap build , happens: when minimized, app paused ( freezes apparently javascript ). solve problem , tested backgroundmode plugin, still same thing. in app there event begins when animation reaches specific frame, not occur when application minimized. well, biggest problem . part of following code : document.addeventlistener("deviceready", function () { window["myphonegap"] = true; // create new runtime using c2canvas cr_createruntime("c2canvas"); document.addeventlistener("pause", function() { cr_setsuspended(false); cordova.plugins.backgroundmode.enable(); }, true); document.addeventlistener("resume", function() { cr_setsuspended(false); cordova.plugins.backgroundmode.disable(); }, true); document.addeventlistener("backbutton", function() { cr_setsu

android - How do I dim an imageview from an ImageAdapter Grid View class? -

i trying create logo quiz, works, unable figure out how modify specific image imageadapter. guidance highly appreciated. thank you! here quiz activity: public class quizactivity extends activity { private interstitialad interstitial; private static int size = 50; public static int location; private int counter = 0; // initialize buttons public static imagebutton buttons[] = new imagebutton[size]; // array names public static string[] names = { "hannibal", "orphan black", "lord of rings", "pretty little liars", "harry potter", "star trek", "the fault in our stars", "iron man", "thor", "frozen", "harry potter", "game of thrones", "hannibal", "doctor who", "sherlock", "attack on titan", "teen wolf", "game of thrones", "doctor who", "sherlock",

localization - Using t() in Drupal 7 -

i've searched how week, haven't success , it's been bottleneck in work so, decided ask. i put <h3><?php print t("strings translation"); ?></h3> in page.tpl.php , flush caches , reload every languages available in site. and try search string in /admin/config/regional/translate/i18n_string options available fields, node types, menu, taxonomy, blocks. but can't find "strings translation" in /admin/config/regional/translate/translate. i have read in drupal.org documentation seems i'm missing something. could please advice how it? are missing echo in code? <h3><?php echo t("strings translation"); ?></h3> i not clear looking for. stringoverrides modeule may solve problem. can translate string across project. but, if string inside t() function.

gradle - Android "has already been added to output" error for jar in a project dependency -

i have android project uses gradle project dependency. dependency project has library jar. when try compile project library compiled twice , error: error:class no.nordicsemi.android.log.logcontract.application has been added output. please remove duplicate copies. here folder structure files in question: >projectroot >dfulibrary >libs -nrf-logger-v2.0.jar -build.gradle >logger -build.gradle this build.gradle dfulibrary dependency: apply plugin: 'com.android.library' android { compilesdkversion 19 buildtoolsversion "19.1.0" defaultconfig { applicationid "no.nordicsemi.android.dfu" minsdkversion 18 targetsdkversion 19 } buildtypes { release { minifyenabled false proguardfiles getdefaultproguardfile('proguard-android.txt'), 'proguard-rules.txt' } } } dependencies { compile 'com.android.support:supp

Elastic search " settings " add in Python module -

how following settings can add python elastic search module. please provide example. have created indexes , mappings. stuck settings. curl -xput "http://localhost:9200/blurays " -d' { "settings": { "analysis": { "filter": { "ngram_filter": { "type": "ngram", "min_gram": 2, "max_gram": 20, "token_chars": [ "letter", "digit", "punctuation", "symbol" ] } }, "analyzer": { "ngram_analyzer": { "type": "custom", "tokenizer": "whitespace", "filter": [ "lowercase", "asciifolding", "ngram_filter" ] },

c++ - how to include class member function inside another class member function -

i need access class member function inside class member function, guess code reuse about. anyways have class , class header file. class has 1 member function calculate average of column in vector. need access average function in function instance datastandardization function below. class.cpp has 2 member function below float table::datatsandardization(int row, int col){ float tablevalue,avg=0; return avg; } another member function calculate average: float table::displaycolaverage(int col){ float sum=0.0,ave; for(register unsigned int i=0; i<vec.size(); i++) { sum = sum + vec[i][col]; } return ave=sum/vec.size(); } now need include average function inside standardization function: example want this: float table::datatsandardization(int row, int col){ float tablevalue,avg=0; avg = displaycolaverage(int col); return avg; } thanks looking @ problem.

android notification opens fragment from Activity -

hello in application need generate notification. for have done private void generatenotification(string message) { mnotificationmanager = (notificationmanager) .getsystemservice(context.notification_service); notificationcompat.builder mbuilder = new notificationcompat.builder( this) /* .setsmallicon(r.drawable.ic_launcher) */ .setsmallicon(r.drawable.app_icon) .setcontenttitle(getresources().getstring(r.string.app_name)) .setstyle( new notificationcompat.bigtextstyle().bigtext(message)) .setticker(message).setcontenttext(message).setautocancel(true); // play default notification sound mbuilder.setdefaults(notification.default_sound | notification.flag_auto_cancel | notification.default_lights); /* * pendingintent cont

createelement - javascript adding new elements with progressive IDs and updating the existing ones -

i have 3 existing boxes on page (divs) unique id (1,2,3) each. want have button each 1 of them allows user add new boxes right below. these boxes should follow existing numbering. however, doing imply update ids of existing boxes underneath new ones numbers match. this code: function add_box(n) { document.getelementbyid("box"+(n<)).setattribute("id", "box"); var div = document.createelement("div"); div.id="box"+(n+1); var txt = document.createtextnode("a new box"); div.appendchild(txt); var newbox = document.getelementbyid("box"+n); insertafter(div,newbox); } html <div id="box1">whatever</div><input type="button" onclick="add_box(1)"> <div id="box2">whatever</div><input type="button" onclick="add_box(2)"> <div id="box3">whatever</div><input type=&qu

javascript - Fifteen Puzzle Empty Tile -

i'm doing fifteen puzzle , trying write function return html id of html tile element holding empty tile. far i'm getting null results. know solution this? <!doctype html> <html lang="en"> <head> <title> fifteen puzzle part iii </title> <meta http-equiv="content-type" content="text/html;charset=utf-8"/> <script src="fifteenpuzzlepart3.js" type="text/javascript"></script> <style type="text/css"> { border : 0; margin : 0; padding : 0; } body { font-family : "times new roman", serif; font-size : 16pt; } #page { background-color: black; color : white; height : 20em; margin-left : auto; margin-right : auto; text-align : center; width : 15em; } #puzzletitle { font-size:25pt; padding-top:10px; padding-bottom:10px; } #puzzleboard { height : 75%; margin-left : auto; margin-right: auto; width : 75%

jquery - Simple animations in Ionic Framework -

can create simple animations in views of ionic framework. animations simple ones, changing of colour, fading, increasing height , width of elements, animations jquery in web pages. yes can, have on this. a powerful javascript animation engine web , hybrid mobile apps, inspired facebook pop, built ionic team . https://github.com/driftyco/collide var animation = collide.animation({ // 'linear|ease|ease-in|ease-out|ease-in-out|cubic-bezer(x1,y1,x2,y2)', // or function(t, duration), // or dynamics configuration (see below) easing: 'ease-in-out', duration: 1000, percent: 0, reverse: false }); // actions, of these return `this` , chainable // .on('step' callback given 'percent', 0-1, argument (for springs outside 0-1 range) // .on('stop' callback given boolean, wascompleted animation.on(/step|destroy|start|stop|complete/, function() {}) animation.once(...) //same event types animation.off(...) //works jquery.off anima

SQL Server left join not giving correct result -

good day, i have read of other problems people facing left joins, not giving correct result , maybe not understanding answers well. here problem having on query select ta.column1 ,d.column2 ,d.column3 ,ta.column4 ,mi.[column5] ,mi.[column6] ,d.[column7] ,d.[column8] ,ta.[column9] ,ta.[column10] ,uc.[column11] ,uc.[column12] ,ta.[column13] ,ta.[column14] ,ta.[column15] ,ta.[column16] ,ta.[column17] ,'0' column18 ,ta.[column19] ,'12.2' column20 ,'none' column21 ,'0' column22 ,'1' column23 ,ta.[column24] ,'0' column25 ,'0' column26 ,ld.column27 [db].[dbo].[table1] ta (nolock) full outer join [db].[dbo].[table2] ld (nolock) on ta.[coulmn1]=ld.[coulmn5] inner join [db].[dbo].[table3] mi (nolock) on ta.coulmn10 = mi.[coulmn3] left join [db