sql server 2008 - Limited result is coming when I run Join query? -

-

i getting only 5001 rows of result when run query:

select      case v_all.job_qty_blankpages         when 0             v_all.job_qty_bwpages + v_all.job_qty_colorpages + (v_all.job_qty_blankpages + ((v_all.job_qty_simplexpages + v_all.job_qty_duplexpages * 2) - (v_all.job_qty_bwpages + v_all.job_qty_colorpages)))         else v_all.job_qty_bwpages + v_all.job_qty_colorpages + v_all.job_qty_blankpages     end printedpages,     v_all.job_qty_bwpages bwpages,     v_all.job_qty_colorpages colorpages,     case v_all.job_qty_blankpages         when 0             v_all.job_qty_blankpages + ((v_all.job_qty_simplexpages + v_all.job_qty_duplexpages * 2) - (v_all.job_qty_bwpages + v_all.job_qty_colorpages))         else v_all.job_qty_blankpages     end blankpages,     v_all.job_qty_simplexpages simplexpages,     v_all.job_qty_duplexpages * 2 duplexpages,     v_all.job_qty_simplexpages + v_all.job_qty_duplexpages totalsheets,     v_all.job_lab_ntdomainname,     v_all.lab_groupname,     v_all.job_lab_ntusername     ,v_all.lab_ntfullusername     ,v_all.printer_lab_location     ,v_all.job_lab_documentname     ,v_all.job_qty_size     ,v_all.job_qty_copies     ,v_all.job_date_submitted     ,t_ad_data.lab_samaccountname     ,t_ad_data.lab_department     ,t_ad_data.lab_physicaldeliveryofficename     v_all left join      t_ad_data on v_all.lab_ntfullusername = t_ad_data.lab_samaccountname      job_date_submitted between '2015-01-01 12:59:59.000'                        , '2015-01-31 12:59:59.000';

first check how many rows there in each table , when u use left join return rows left table (v_all), matching rows in right table (t_ad_data).

so check whether have non matching rows between these tables. if there need change join condition.


Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5&quo
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name&qu
Read more

javascript - Chrome Extension: Interacting with iframe embedded within popup -

-
i writing chrome extension needs interact urls user not have open. therefore using hidden iframes embedded within popup, , attempting click button within iframe. however, receiving same origin policy error. know possible extension interact iframes of different domain via content scripts when iframe on tab user has open, not sure if possible use content scripts interact iframes directly in popup. here code: manifest.json "content_scripts": [ { "js": [ "bin/jquery.min.js", "interaction.js" ], "all_frames": true, "run_at": "document_start", "matches": [ "http://*/*", "https://*/*" ] }], "permissions": [ "activetab", "tabs", "http://*/", "https://*/" ], interaction.js $(document).ready(function() { $('div#iframes').append("<iframe id='shop' src=
Read more