{"id":270,"date":"2014-09-16T14:37:45","date_gmt":"2014-09-16T11:37:45","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=270"},"modified":"2014-09-18T10:36:28","modified_gmt":"2014-09-18T07:36:28","slug":"mikro-raporlarda-seri-sira-filtresi","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/mikro-raporlarda-seri-sira-filtresi\/","title":{"rendered":"Mikro Raporlarda seri s\u0131ra filtresi"},"content":{"rendered":"

Mikro Raporlarda seri s\u0131ra filtresii\u00e7in sql sorgular\u0131<\/p>\n

<\/p>\n

–SELECT ban_kredi_tavan FROM BANKALAR WHERE ban_kod=’B001′<\/p>\n

SELECT<\/p>\n

((SELECT\u00a0ban_kredi_tavan\u00a0FROM\u00a0BANKALAR\u00a0WHEREban_kod=dbo.CARI_HESAP_HAREKETLERI.cha_kod)-(cha_meblag))\u00a0as\u00a0KALANKRD<\/p>\n

–(cha_evrakno_seri + ‘-‘ +\u00a0cha_evrakno_sira\u00a0) as evrakno<\/p>\n

FROM\u00a0CARI_HESAP_HAREKETLERI\u00a0WHERE\u00a0(cha_evrakno_seri+’-‘+convert(nvarchar,cha_evrakno_sira))=’BN-1′<\/p>\n

–cha_evrakno_seri=’BN’ and\u00a0cha_evrakno_sira=’1′ and cha_evrak_tip=’8′<\/p>\n

select\u00a0(cha_evrakno_seri+’-‘+convert(nvarchar,cha_evrakno_sira))\u00a0fromCARI_HESAP_HAREKETLERI<\/p>\n

 <\/p>\n

 <\/p>\n

SELECT<\/p>\n

((SELECT\u00a0ban_kredi_tavan\u00a0FROM\u00a0BANKALAR\u00a0WHEREban_kod=dbo.CARI_HESAP_HAREKETLERI.cha_kod)-(cha_meblag))\u00a0as\u00a0KALANKRD<\/p>\n

FROM\u00a0CARI_HESAP_HAREKETLERI\u00a0WHERE\u00a0(cha_evrakno_seri+’-‘+convert(nvarchar,cha_evrakno_sira))=’BN-1’<\/p>\n

 <\/p>\n

veya<\/p>\n

fn_EvrNoForm fonksiyonunu kullanman\u0131n\u0131z<\/p>\n","protected":false},"excerpt":{"rendered":"

Mikro Raporlarda seri s\u0131ra filtresii\u00e7in sql sorgular\u0131<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-270","post","type-post","status-publish","format-standard","hentry","category-mikro-yazilimevi"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=270"}],"version-history":[{"count":2,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/270\/revisions"}],"predecessor-version":[{"id":359,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/270\/revisions\/359"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}