<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/">
	<channel>
		<title><![CDATA[Access SQL - MS SQL SERVER]]></title>
		<link>https://www.access-sql.com/</link>
		<description><![CDATA[Access SQL - https://www.access-sql.com]]></description>
		<pubDate>Thu, 19 Nov 2026 21:02:00 +0000</pubDate>
		<generator>MyBB</generator>
		<item>
			<title><![CDATA[Ms Sql - Iki Muhasebe Programı Arasında Veri Aktarımı Problemi]]></title>
			<link>https://www.access-sql.com/Konu-Ms-Sql-Iki-Muhasebe-Programi-Arasinda-Veri-Aktarimi-Problemi</link>
			<pubDate>Mon, 02 Dec 2024 22:13:14 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Ms-Sql-Iki-Muhasebe-Programi-Arasinda-Veri-Aktarimi-Problemi</guid>
			<description><![CDATA[Merhabalar, SQL tarafında yeniyim. İki muhasebe programı arasında veri aktarımı yapmak istiyorum. Query yazdım her şey doğru gibi ancak veriyi aktaracağım zaman verinin aktarılacağı program "FIS_TIP" bulunamadı hatası veriyor. Ne yaptıysam çözemedim. Şimdiden yardımlarınız için teşekkür eder, iyi çalışmalar dilerim.<br />
<br />
<div class="codeblock"><div class="title">Visual Basic</div><div class="body"><code><pre class="vba" style="font-family:monospace;"><ol><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">SELECT</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>FIS_TIP<span style="color: #7B927B;">,</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>FIS_NO<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>TARIH<span style="color: #7B927B;">,</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>ACIKLAMA1<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BELGE_TARIH<span style="color: #7B927B;">,</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BELGE_TUR<span style="color: #7B927B;">,</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BELGE_NO<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>ACIKLAMA<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BORC_MIKTARI<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>ALACAK_MIKTARI<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BORC_TUTARI<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>ALACAK_TUTARI<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  HESAP<span style="color: #7B927B;">.</span>KOD<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  HESAP<span style="color: #7B927B;">.</span>HESAP_ADI<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">&nbsp;</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  <span style="color: #268bd2; font-weight: bold;">CASE</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN BSL<span style="color: #7B927B;">.</span>FIS_TIP <span style="color: #7B927B;">=</span> <span style="color: #008000;">'DA46BCD3-AC3C-40D1-8485-8EF988E78B56' THEN '1'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"> WHEN BSL<span style="color: #7B927B;">.</span>FIS_TIP <span style="color: #7B927B;">=</span> <span style="color: #008000;">'F5B9E66D-8EFC-491B-A618-24948F3F83F8' THEN '4'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"> WHEN BSL<span style="color: #7B927B;">.</span>FIS_TIP <span style="color: #7B927B;">=</span> <span style="color: #008000;">'2D606046-EF37-4823-AAE1-6DBFDAF7196F' THEN '4'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"> WHEN BSL<span style="color: #7B927B;">.</span>FIS_TIP <span style="color: #7B927B;">=</span> <span style="color: #008000;">'50DCF09A-C85A-4A43-B8EB-3EDBFF3C5820' THEN '4'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"> WHEN BSL<span style="color: #7B927B;">.</span>FIS_TIP <span style="color: #7B927B;">=</span> <span style="color: #008000;">'5303A215-949E-4C47-80E0-25FED770E0BE' THEN '6'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  <span style="color: #268bd2; font-weight: bold;">END</span> <span style="color: #151B8D; font-weight: bold;">AS</span> fistip<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>FIS_NO <span style="color: #151B8D; font-weight: bold;">as</span> fisno<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>TARIH <span style="color: #151B8D; font-weight: bold;">as</span> fistarih<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>ACIKLAMA1 <span style="color: #151B8D; font-weight: bold;">AS</span> fisaciklama<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BELGE_TARIH <span style="color: #151B8D; font-weight: bold;">AS</span> belgetarih<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  <span style="color: #268bd2; font-weight: bold;">CASE</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'91DE264F-01CD-4f57-BFA5-782985B47879' THEN '20'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'4164379E-BC29-4b4d-9FED-995D648C3865' THEN '7'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'C2A941C0-078D-43a3-9370-D053D019AB4B' THEN '20'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'4496E337-A81F-460b-B4BF-72CC11D09060' THEN '414'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'53352E3F-EBD4-4460-9BA3-2A6CDBF947FB' THEN '416'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'BF55F734-F3AD-4820-8F46-94B6D58D6912' THEN '89'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'492862AE-8EFC-4D07-838D-A50807ABD034' THEN '88'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'A76C856F-2456-4589-8765-1CAD45A8EBA1' THEN '97'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'99D603BF-2FA0-4F78-8956-618820E57FCD' THEN '95'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'6A7375C9-B771-4A6B-9F42-FDB6D3BC122B' THEN '35'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'BA3EF528-8F29-4DB6-981B-55D70AAC1D31' THEN '34'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'76563DDC-A67A-4A51-A3C5-ED4857858F2E' THEN '96'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'5AC7F0E2-A18E-4B3C-AD0F-567D44E336B4' THEN '45'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'2065E605-9609-4DF1-A627-E3A69D5ACE30' THEN '414'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'4C1EA22F-B0AF-464D-B25D-95C8BA7DDBD2' THEN '414'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'D3BF0835-AAFD-4DE5-AAE0-8A84AEEAE4D2' THEN '46'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'345575AD-4DD5-4FA0-A4C7-3CFDF99D4DD9' THEN '55'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'A9A94EE3-E22B-4AE4-B99C-77530FC3913F' THEN '54'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'C10C63DE-CEDE-4478-8D9A-3864923376AD' THEN '413'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'BE9B528F-C8D1-43FC-B2CB-EA0BC42A8F10' THEN '414'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'DE6C2A46-B739-4299-B34E-B858D716D13F' THEN '20'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'0C7732FF-71E9-46D3-BE88-8D0DAB7CFE64' THEN '20'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'5D1948B7-3632-40F0-B823-513AEDA1354C' THEN '97'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'B74D208A-1D38-4EEF-9E71-032EC58318A2' THEN '20'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'CFD6AFD6-B0D2-413F-9414-D870FD7EBFF5' THEN '55'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'5C57DA80-B8AD-4A8B-9790-05939D2FA9FB' THEN '99'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'521E3C16-8C9E-4010-8016-7D03623F23CE' THEN '99'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'3D6837F8-6566-422B-A843-58C01FB0A380' THEN '55'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'EB4D5A61-CC40-4C39-9F15-C217D4C90047' THEN '35'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'455D9B57-BD19-4128-A534-2820BD45388F' THEN '414'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'DAB004AF-F05F-48A4-935A-9BD9BF3076D5' THEN '57'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'58467D4E-79C2-4679-8E67-1B5D85A2B2CC' THEN '34'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    <span style="color: #268bd2; font-weight: bold;">ELSE</span> <span style="color: #008000;">'414'  -- Varsayılan değer</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  <span style="color: #268bd2; font-weight: bold;">END</span> <span style="color: #151B8D; font-weight: bold;">AS</span> belgetipi<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BELGE_NO  <span style="color: #151B8D; font-weight: bold;">AS</span> belgeserino<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BELGE_NO <span style="color: #151B8D; font-weight: bold;">AS</span> belgeno<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>ACIKLAMA <span style="color: #151B8D; font-weight: bold;">AS</span> aciklama<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BORC_MIKTARI <span style="color: #151B8D; font-weight: bold;">AS</span> miktar<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>ALACAK_MIKTARI <span style="color: #151B8D; font-weight: bold;">AS</span> miktar<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BORC_TUTARI <span style="color: #151B8D; font-weight: bold;">AS</span> borctutar<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>ALACAK_TUTARI <span style="color: #151B8D; font-weight: bold;">AS</span> alactutar<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  <span style="color: #718c00; font-weight: bold;">REPLACE</span><span style="color: #7B927B;">(</span><span style="color: #718c00; font-weight: bold;">REPLACE</span><span style="color: #7B927B;">(</span><span style="color: #268bd2; font-weight: bold;">CASE</span> WHEN <span style="color: #718c00; font-weight: bold;">LEN</span><span style="color: #7B927B;">(</span>HESAP<span style="color: #7B927B;">.</span>KOD<span style="color: #7B927B;">)=</span>3 <span style="color: #268bd2; font-weight: bold;">THEN</span> HESAP<span style="color: #7B927B;">.</span>KOD <span style="color: #7B927B;">+</span> <span style="color: #008000;">' 999'   ELSE HESAP.KOD END,'.',' '),'-',' ') AS hesapkodu_01,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  HESAP<span style="color: #7B927B;">.</span>HESAP_ADI <span style="color: #151B8D; font-weight: bold;">AS</span> hesapadi_01</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">FROM </div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    [dbo]<span style="color: #7B927B;">.</span>[F0001_2024_T_BIL_FIS_BSL] <span style="color: #151B8D; font-weight: bold;">AS</span> BSL</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">INNER JOIN </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    [dbo]<span style="color: #7B927B;">.</span>[F0001_2024_T_BIL_FIS_SATIR] <span style="color: #151B8D; font-weight: bold;">AS</span> SATIR <span style="color: #151B8D; font-weight: bold;">ON</span> BSL<span style="color: #7B927B;">.</span>ID <span style="color: #7B927B;">=</span> SATIR<span style="color: #7B927B;">.</span>FIS_ID</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">INNER JOIN </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    [dbo]<span style="color: #7B927B;">.</span>[F0001_2024_T_BIL_HESAP_PLAN] <span style="color: #151B8D; font-weight: bold;">AS</span> HESAP <span style="color: #151B8D; font-weight: bold;">ON</span> SATIR<span style="color: #7B927B;">.</span>HESAP_KODU <span style="color: #7B927B;">=</span> HESAP<span style="color: #7B927B;">.</span>ID;</div></li></ol></pre></code></div></div><br /><br />
]]></description>
			<content:encoded><![CDATA[Merhabalar, SQL tarafında yeniyim. İki muhasebe programı arasında veri aktarımı yapmak istiyorum. Query yazdım her şey doğru gibi ancak veriyi aktaracağım zaman verinin aktarılacağı program "FIS_TIP" bulunamadı hatası veriyor. Ne yaptıysam çözemedim. Şimdiden yardımlarınız için teşekkür eder, iyi çalışmalar dilerim.<br />
<br />
<div class="codeblock"><div class="title">Visual Basic</div><div class="body"><code><pre class="vba" style="font-family:monospace;"><ol><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">SELECT</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>FIS_TIP<span style="color: #7B927B;">,</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>FIS_NO<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>TARIH<span style="color: #7B927B;">,</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>ACIKLAMA1<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BELGE_TARIH<span style="color: #7B927B;">,</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BELGE_TUR<span style="color: #7B927B;">,</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BELGE_NO<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>ACIKLAMA<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BORC_MIKTARI<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>ALACAK_MIKTARI<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BORC_TUTARI<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>ALACAK_TUTARI<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  HESAP<span style="color: #7B927B;">.</span>KOD<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  HESAP<span style="color: #7B927B;">.</span>HESAP_ADI<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">&nbsp;</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  <span style="color: #268bd2; font-weight: bold;">CASE</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN BSL<span style="color: #7B927B;">.</span>FIS_TIP <span style="color: #7B927B;">=</span> <span style="color: #008000;">'DA46BCD3-AC3C-40D1-8485-8EF988E78B56' THEN '1'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"> WHEN BSL<span style="color: #7B927B;">.</span>FIS_TIP <span style="color: #7B927B;">=</span> <span style="color: #008000;">'F5B9E66D-8EFC-491B-A618-24948F3F83F8' THEN '4'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"> WHEN BSL<span style="color: #7B927B;">.</span>FIS_TIP <span style="color: #7B927B;">=</span> <span style="color: #008000;">'2D606046-EF37-4823-AAE1-6DBFDAF7196F' THEN '4'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"> WHEN BSL<span style="color: #7B927B;">.</span>FIS_TIP <span style="color: #7B927B;">=</span> <span style="color: #008000;">'50DCF09A-C85A-4A43-B8EB-3EDBFF3C5820' THEN '4'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"> WHEN BSL<span style="color: #7B927B;">.</span>FIS_TIP <span style="color: #7B927B;">=</span> <span style="color: #008000;">'5303A215-949E-4C47-80E0-25FED770E0BE' THEN '6'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  <span style="color: #268bd2; font-weight: bold;">END</span> <span style="color: #151B8D; font-weight: bold;">AS</span> fistip<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>FIS_NO <span style="color: #151B8D; font-weight: bold;">as</span> fisno<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>TARIH <span style="color: #151B8D; font-weight: bold;">as</span> fistarih<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  BSL<span style="color: #7B927B;">.</span>ACIKLAMA1 <span style="color: #151B8D; font-weight: bold;">AS</span> fisaciklama<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BELGE_TARIH <span style="color: #151B8D; font-weight: bold;">AS</span> belgetarih<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  <span style="color: #268bd2; font-weight: bold;">CASE</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'91DE264F-01CD-4f57-BFA5-782985B47879' THEN '20'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'4164379E-BC29-4b4d-9FED-995D648C3865' THEN '7'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'C2A941C0-078D-43a3-9370-D053D019AB4B' THEN '20'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'4496E337-A81F-460b-B4BF-72CC11D09060' THEN '414'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'53352E3F-EBD4-4460-9BA3-2A6CDBF947FB' THEN '416'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'BF55F734-F3AD-4820-8F46-94B6D58D6912' THEN '89'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'492862AE-8EFC-4D07-838D-A50807ABD034' THEN '88'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'A76C856F-2456-4589-8765-1CAD45A8EBA1' THEN '97'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'99D603BF-2FA0-4F78-8956-618820E57FCD' THEN '95'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'6A7375C9-B771-4A6B-9F42-FDB6D3BC122B' THEN '35'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'BA3EF528-8F29-4DB6-981B-55D70AAC1D31' THEN '34'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'76563DDC-A67A-4A51-A3C5-ED4857858F2E' THEN '96'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'5AC7F0E2-A18E-4B3C-AD0F-567D44E336B4' THEN '45'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'2065E605-9609-4DF1-A627-E3A69D5ACE30' THEN '414'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'4C1EA22F-B0AF-464D-B25D-95C8BA7DDBD2' THEN '414'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'D3BF0835-AAFD-4DE5-AAE0-8A84AEEAE4D2' THEN '46'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'345575AD-4DD5-4FA0-A4C7-3CFDF99D4DD9' THEN '55'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'A9A94EE3-E22B-4AE4-B99C-77530FC3913F' THEN '54'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'C10C63DE-CEDE-4478-8D9A-3864923376AD' THEN '413'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'BE9B528F-C8D1-43FC-B2CB-EA0BC42A8F10' THEN '414'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'DE6C2A46-B739-4299-B34E-B858D716D13F' THEN '20'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'0C7732FF-71E9-46D3-BE88-8D0DAB7CFE64' THEN '20'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'5D1948B7-3632-40F0-B823-513AEDA1354C' THEN '97'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'B74D208A-1D38-4EEF-9E71-032EC58318A2' THEN '20'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'CFD6AFD6-B0D2-413F-9414-D870FD7EBFF5' THEN '55'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'5C57DA80-B8AD-4A8B-9790-05939D2FA9FB' THEN '99'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'521E3C16-8C9E-4010-8016-7D03623F23CE' THEN '99'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'3D6837F8-6566-422B-A843-58C01FB0A380' THEN '55'</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'EB4D5A61-CC40-4C39-9F15-C217D4C90047' THEN '35'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'455D9B57-BD19-4128-A534-2820BD45388F' THEN '414'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'DAB004AF-F05F-48A4-935A-9BD9BF3076D5' THEN '57'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    WHEN SATIR<span style="color: #7B927B;">.</span>BELGE_TUR <span style="color: #7B927B;">=</span> <span style="color: #008000;">'58467D4E-79C2-4679-8E67-1B5D85A2B2CC' THEN '34'</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    <span style="color: #268bd2; font-weight: bold;">ELSE</span> <span style="color: #008000;">'414'  -- Varsayılan değer</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  <span style="color: #268bd2; font-weight: bold;">END</span> <span style="color: #151B8D; font-weight: bold;">AS</span> belgetipi<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BELGE_NO  <span style="color: #151B8D; font-weight: bold;">AS</span> belgeserino<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BELGE_NO <span style="color: #151B8D; font-weight: bold;">AS</span> belgeno<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>ACIKLAMA <span style="color: #151B8D; font-weight: bold;">AS</span> aciklama<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BORC_MIKTARI <span style="color: #151B8D; font-weight: bold;">AS</span> miktar<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>ALACAK_MIKTARI <span style="color: #151B8D; font-weight: bold;">AS</span> miktar<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>BORC_TUTARI <span style="color: #151B8D; font-weight: bold;">AS</span> borctutar<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  SATIR<span style="color: #7B927B;">.</span>ALACAK_TUTARI <span style="color: #151B8D; font-weight: bold;">AS</span> alactutar<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  <span style="color: #718c00; font-weight: bold;">REPLACE</span><span style="color: #7B927B;">(</span><span style="color: #718c00; font-weight: bold;">REPLACE</span><span style="color: #7B927B;">(</span><span style="color: #268bd2; font-weight: bold;">CASE</span> WHEN <span style="color: #718c00; font-weight: bold;">LEN</span><span style="color: #7B927B;">(</span>HESAP<span style="color: #7B927B;">.</span>KOD<span style="color: #7B927B;">)=</span>3 <span style="color: #268bd2; font-weight: bold;">THEN</span> HESAP<span style="color: #7B927B;">.</span>KOD <span style="color: #7B927B;">+</span> <span style="color: #008000;">' 999'   ELSE HESAP.KOD END,'.',' '),'-',' ') AS hesapkodu_01,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  HESAP<span style="color: #7B927B;">.</span>HESAP_ADI <span style="color: #151B8D; font-weight: bold;">AS</span> hesapadi_01</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">FROM </div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    [dbo]<span style="color: #7B927B;">.</span>[F0001_2024_T_BIL_FIS_BSL] <span style="color: #151B8D; font-weight: bold;">AS</span> BSL</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">INNER JOIN </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    [dbo]<span style="color: #7B927B;">.</span>[F0001_2024_T_BIL_FIS_SATIR] <span style="color: #151B8D; font-weight: bold;">AS</span> SATIR <span style="color: #151B8D; font-weight: bold;">ON</span> BSL<span style="color: #7B927B;">.</span>ID <span style="color: #7B927B;">=</span> SATIR<span style="color: #7B927B;">.</span>FIS_ID</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">INNER JOIN </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    [dbo]<span style="color: #7B927B;">.</span>[F0001_2024_T_BIL_HESAP_PLAN] <span style="color: #151B8D; font-weight: bold;">AS</span> HESAP <span style="color: #151B8D; font-weight: bold;">ON</span> SATIR<span style="color: #7B927B;">.</span>HESAP_KODU <span style="color: #7B927B;">=</span> HESAP<span style="color: #7B927B;">.</span>ID;</div></li></ol></pre></code></div></div><br /><br />
]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Sorgu Sonucunu Tabloya Eklemek]]></title>
			<link>https://www.access-sql.com/Konu-Sorgu-Sonucunu-Tabloya-Eklemek</link>
			<pubDate>Mon, 18 Sep 2023 09:55:20 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Sorgu-Sonucunu-Tabloya-Eklemek</guid>
			<description><![CDATA[merhaba aşağıdaki mssql sorgusu ile  bir xml  kodu oluşturuyorum<br />
çıkan xml  kodunu   hiç değiştirmeden <br />
<br />
TABLO1 tablosunun ADRESXMLKODU alanıına nasıl ekleyebilirim <br />
<br />
yardımlarınız için şimdiden teşekürler.<br />
 <br />
SELECT ADRES  FROM dbo.FIRMALAR FOR XML PATH('FIRMALAR')]]></description>
			<content:encoded><![CDATA[merhaba aşağıdaki mssql sorgusu ile  bir xml  kodu oluşturuyorum<br />
çıkan xml  kodunu   hiç değiştirmeden <br />
<br />
TABLO1 tablosunun ADRESXMLKODU alanıına nasıl ekleyebilirim <br />
<br />
yardımlarınız için şimdiden teşekürler.<br />
 <br />
SELECT ADRES  FROM dbo.FIRMALAR FOR XML PATH('FIRMALAR')]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Oluşturulan Tablo Ile Sorguyu Birbirine Bağlama]]></title>
			<link>https://www.access-sql.com/Konu-Olusturulan-Tablo-Ile-Sorguyu-Birbirine-Baglama</link>
			<pubDate>Fri, 16 Dec 2022 11:45:24 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Olusturulan-Tablo-Ile-Sorguyu-Birbirine-Baglama</guid>
			<description><![CDATA[Arkadaşlar merhaba;<br />
Sql server'da çok yeniyim. şuan sürekli denemeler halindeyim. bir işlem yapmak istiyorum. alttaki gibi bir tablo oluşturdum. daha sonra bir sorgu yazdım. sorguda da bu tabloların başlıklarının karşılığı var. Şimdi ben yazmış olduğum sorguyu bu tabloyla nasıl eşletiriyorum. Ne yapmam lazım bana yardımcı olabilir misiniz ?]]></description>
			<content:encoded><![CDATA[Arkadaşlar merhaba;<br />
Sql server'da çok yeniyim. şuan sürekli denemeler halindeyim. bir işlem yapmak istiyorum. alttaki gibi bir tablo oluşturdum. daha sonra bir sorgu yazdım. sorguda da bu tabloların başlıklarının karşılığı var. Şimdi ben yazmış olduğum sorguyu bu tabloyla nasıl eşletiriyorum. Ne yapmam lazım bana yardımcı olabilir misiniz ?]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Sql Server Sorunu :(]]></title>
			<link>https://www.access-sql.com/Konu-Sql-Server-Sorunu</link>
			<pubDate>Fri, 24 Jun 2022 10:45:39 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Sql-Server-Sorunu</guid>
			<description><![CDATA[Merhaba arkadaşlar , sorunum gerçekten de konu başlığında ki gibi mi bilmiyorum ama çok büyük bir sorunum var.<br />
Şişlide ufak bir bilgisayar firmasında çalışmaktayım. Kumaş sektöründe olan bir firmaya server kurulumu ve modem değişikliği yaptım ve daha önce kendilerinin kullandığı özel olarak yazdırılmış muhasebe programı mevcut.<br />
Bu programı servere taşıdım ve paylaşıma açtım , ancak program açılmıyor.<br />
Bu programın bütün dosyaları serverda olacak şekilde diğer kullanıcıların .exe dosyasını açarak kullanmasını istiyorum.<br />
Lütfen yardımcı olabilir misiniz ?<br />
<span style="font-weight: bold;" class="mycode_b">SQL ACCESS hakkında hiç bir fikrim yok</span> ve programın bağlantıları sanırım bu şekilde.<br />
<span style="font-weight: bold;" class="mycode_b">Sizden ricam programın bütün dosyalarını rar yaparak , sql access bağlantı değilde daha basit bir şekilde kodlama yapabilir misiniz?</span><br />
Çok memnun kalırım gerçekten çok yardıma ihtiyacım var.<br />
<br />
<br />
Aldığım hata aşağıda ki gibidir .<br />
<br />
<br />
<img src="https://i.hizliresim.com/qccot6p.png" alt="[Resim: qccot6p.png]" class="mycode_img" />]]></description>
			<content:encoded><![CDATA[Merhaba arkadaşlar , sorunum gerçekten de konu başlığında ki gibi mi bilmiyorum ama çok büyük bir sorunum var.<br />
Şişlide ufak bir bilgisayar firmasında çalışmaktayım. Kumaş sektöründe olan bir firmaya server kurulumu ve modem değişikliği yaptım ve daha önce kendilerinin kullandığı özel olarak yazdırılmış muhasebe programı mevcut.<br />
Bu programı servere taşıdım ve paylaşıma açtım , ancak program açılmıyor.<br />
Bu programın bütün dosyaları serverda olacak şekilde diğer kullanıcıların .exe dosyasını açarak kullanmasını istiyorum.<br />
Lütfen yardımcı olabilir misiniz ?<br />
<span style="font-weight: bold;" class="mycode_b">SQL ACCESS hakkında hiç bir fikrim yok</span> ve programın bağlantıları sanırım bu şekilde.<br />
<span style="font-weight: bold;" class="mycode_b">Sizden ricam programın bütün dosyalarını rar yaparak , sql access bağlantı değilde daha basit bir şekilde kodlama yapabilir misiniz?</span><br />
Çok memnun kalırım gerçekten çok yardıma ihtiyacım var.<br />
<br />
<br />
Aldığım hata aşağıda ki gibidir .<br />
<br />
<br />
<img src="https://i.hizliresim.com/qccot6p.png" alt="[Resim: qccot6p.png]" class="mycode_img" />]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Hata:geçerli Işlem Yürütülemiyor Ve Günlük Dosyasına Yazan Işlemleri Destekleyemiyor]]></title>
			<link>https://www.access-sql.com/Konu-Hata-gecerli-Islem-Yurutulemiyor-Ve-Gunluk-Dosyasina-Yazan-Islemleri-Destekleyemiyor</link>
			<pubDate>Mon, 04 Apr 2022 15:02:17 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Hata-gecerli-Islem-Yurutulemiyor-Ve-Gunluk-Dosyasina-Yazan-Islemleri-Destekleyemiyor</guid>
			<description><![CDATA[Bu hata ne anlama geliyor acaba?<br />
<br />
Errorline: 9<br />
Error_Message : The current transaction cannot be executed and cannot support transactions that write to the log file. Undo the action.<br />
Error_Number : 3930<br />
ErrorSeverity: 16<br />
ErrorState: 1]]></description>
			<content:encoded><![CDATA[Bu hata ne anlama geliyor acaba?<br />
<br />
Errorline: 9<br />
Error_Message : The current transaction cannot be executed and cannot support transactions that write to the log file. Undo the action.<br />
Error_Number : 3930<br />
ErrorSeverity: 16<br />
ErrorState: 1]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Acces Sorguyu Msserver 'de Kullanma Hatası]]></title>
			<link>https://www.access-sql.com/Konu-Acces-Sorguyu-Msserver-de-Kullanma-Hatasi</link>
			<pubDate>Tue, 15 Mar 2022 14:23:30 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Acces-Sorguyu-Msserver-de-Kullanma-Hatasi</guid>
			<description><![CDATA[Merhaba arkadaşlar<br />
<br />
SELECT Tbl_SFaturalar.faturaNo, Tbl_SFaturalar.Secenek, Tbl_SFaturalar.RefNo, Tbl_SFaturalar.FTarih, Tbl_SFaturalar.Plaka, Tbl_SFaturalar.Firmaadi, Tbl_SFaturalar.YukYeri, Tbl_SFaturalar.PBirimi, Sum([Adet]) AS Ad, Sum([BrimFiyat]) AS BF, Last([Kdvorani]) AS KO, Sum([KdvTutar]) AS KT, Sum([Toplam]) AS TT, Last([GumrukTutar]) AS GT <br />
         FROM Tbl_SFaturalar<br />
        GROUP BY Tbl_SFaturalar.faturaNo, Tbl_SFaturalar.Secenek, Tbl_SFaturalar.RefNo, Tbl_SFaturalar.FTarih, Tbl_SFaturalar.Plaka, Tbl_SFaturalar.Firmaadi, Tbl_SFaturalar.YukYeri, Tbl_SFaturalar.PBirimi <br />
        HAVING (((Tbl_SFaturalar.faturaNo) Like '%" &amp; txtFatNo.Text &amp; "%') AND ((Tbl_SFaturalar.Secenek) Like '%" &amp; txtSecenek.Text &amp; "%') AND ((Tbl_SFaturalar.RefNo) Like '%" &amp; txtRefNo.Text &amp; "%')) AND ((Tbl_SFaturalar.Firmaadi) Like '%" &amp; txtFirmaadi.Text &amp; "%') AND ((Tbl_SFaturalar.Plaka) Like '%" &amp; txtPlaka.Text &amp; "%') AND ((Tbl_SFaturalar.Yukyeri) Like '%" &amp; txtYukyeri.Text &amp; "%')<br />
<br />
<br />
Yukarıda acces te yaptıgım sorgu,Msserver de kullanırken hata veriyor. uyarıda last( ..gibi  hata oldugunu bildiriyor,sanırım Last kullanamıyorum,bunun yerine ne kullanmalıyım yada;<br />
bu sorguyu aynı şekilde ve yapıda Msserverde kullanılacak şekilde çevirebilecek arkadaş varsa çevirebilirmi,yada bu konu ile ilgili bana bilgi verebilecek varmıdır.<br />
Cevaplarınız için şimdiden teşekkürler]]></description>
			<content:encoded><![CDATA[Merhaba arkadaşlar<br />
<br />
SELECT Tbl_SFaturalar.faturaNo, Tbl_SFaturalar.Secenek, Tbl_SFaturalar.RefNo, Tbl_SFaturalar.FTarih, Tbl_SFaturalar.Plaka, Tbl_SFaturalar.Firmaadi, Tbl_SFaturalar.YukYeri, Tbl_SFaturalar.PBirimi, Sum([Adet]) AS Ad, Sum([BrimFiyat]) AS BF, Last([Kdvorani]) AS KO, Sum([KdvTutar]) AS KT, Sum([Toplam]) AS TT, Last([GumrukTutar]) AS GT <br />
         FROM Tbl_SFaturalar<br />
        GROUP BY Tbl_SFaturalar.faturaNo, Tbl_SFaturalar.Secenek, Tbl_SFaturalar.RefNo, Tbl_SFaturalar.FTarih, Tbl_SFaturalar.Plaka, Tbl_SFaturalar.Firmaadi, Tbl_SFaturalar.YukYeri, Tbl_SFaturalar.PBirimi <br />
        HAVING (((Tbl_SFaturalar.faturaNo) Like '%" &amp; txtFatNo.Text &amp; "%') AND ((Tbl_SFaturalar.Secenek) Like '%" &amp; txtSecenek.Text &amp; "%') AND ((Tbl_SFaturalar.RefNo) Like '%" &amp; txtRefNo.Text &amp; "%')) AND ((Tbl_SFaturalar.Firmaadi) Like '%" &amp; txtFirmaadi.Text &amp; "%') AND ((Tbl_SFaturalar.Plaka) Like '%" &amp; txtPlaka.Text &amp; "%') AND ((Tbl_SFaturalar.Yukyeri) Like '%" &amp; txtYukyeri.Text &amp; "%')<br />
<br />
<br />
Yukarıda acces te yaptıgım sorgu,Msserver de kullanırken hata veriyor. uyarıda last( ..gibi  hata oldugunu bildiriyor,sanırım Last kullanamıyorum,bunun yerine ne kullanmalıyım yada;<br />
bu sorguyu aynı şekilde ve yapıda Msserverde kullanılacak şekilde çevirebilecek arkadaş varsa çevirebilirmi,yada bu konu ile ilgili bana bilgi verebilecek varmıdır.<br />
Cevaplarınız için şimdiden teşekkürler]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Negatif Değerleri Göre Bilmek Için Yazdığım Kodda Desteklerinize Ihtiyacım Var]]></title>
			<link>https://www.access-sql.com/Konu-Negatif-Degerleri-Gore-Bilmek-Icin-Yazdigim-Kodda-Desteklerinize-Ihtiyacim-Var</link>
			<pubDate>Sat, 06 Nov 2021 15:45:17 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Negatif-Degerleri-Gore-Bilmek-Icin-Yazdigim-Kodda-Desteklerinize-Ihtiyacim-Var</guid>
			<description><![CDATA[Merhabalar<br />
<br />
Aşağıdaki Kodda negatif değeri göremiyorum<br />
<br />
Cast((JULIANDAY((Table1_Verisi.Kesinti_Suresi/86400)) -JULIANDAY((0))) as integer) || " Gün " || time((Table1_Verisi.Kesinti_Suresi), "unixepoch") AS Kesinti_Sure<br />
<br />
Yukarıdaki Kodda  (0 Gün 00:00:00) şeklinde değer alıyorum.<br />
<br />
Negatif değerleri (- 0 Gün 00:00:00) şeklinde görmem gerekiyor bu konuda yardımcı olabilir misiniz?]]></description>
			<content:encoded><![CDATA[Merhabalar<br />
<br />
Aşağıdaki Kodda negatif değeri göremiyorum<br />
<br />
Cast((JULIANDAY((Table1_Verisi.Kesinti_Suresi/86400)) -JULIANDAY((0))) as integer) || " Gün " || time((Table1_Verisi.Kesinti_Suresi), "unixepoch") AS Kesinti_Sure<br />
<br />
Yukarıdaki Kodda  (0 Gün 00:00:00) şeklinde değer alıyorum.<br />
<br />
Negatif değerleri (- 0 Gün 00:00:00) şeklinde görmem gerekiyor bu konuda yardımcı olabilir misiniz?]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Sql Ile Iki Kolon Arasındaki Değer]]></title>
			<link>https://www.access-sql.com/Konu-Sql-Ile-Iki-Kolon-Arasindaki-Deger</link>
			<pubDate>Thu, 16 Sep 2021 18:41:41 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Sql-Ile-Iki-Kolon-Arasindaki-Deger</guid>
			<description><![CDATA[<span style="color: #141414;" class="mycode_color"><span style="font-size: small;" class="mycode_size">Merhabalar</span></span><br />
<br />
<span style="color: #141414;" class="mycode_color"><span style="font-size: small;" class="mycode_size">Access de bir tablom var. 3 kolondan oluşuyor. 17 sayısını sql ile min ile max değer arasında sorgulama yaparak AR kolondaki değeri almak istiyorum</span></span><br />
<br />
<br />
<span style="color: #141414;" class="mycode_color"><span style="font-size: small;" class="mycode_size"><!-- start: postbit_attachments_attachment -->
<br /><!-- start: attachment_icon -->
<img src="https://www.access-sql.com/images/attachtypes/image.gif" title="PNG Image" border="0" alt=".png" />
<!-- end: attachment_icon -->&nbsp;&nbsp;<a href="attachment.php?aid=24543" target="_blank" title="">Screenshot_5.png</a> (Boyut: 3,08 KB / İndirilme: 7)
<!-- end: postbit_attachments_attachment --></span> </span>]]></description>
			<content:encoded><![CDATA[<span style="color: #141414;" class="mycode_color"><span style="font-size: small;" class="mycode_size">Merhabalar</span></span><br />
<br />
<span style="color: #141414;" class="mycode_color"><span style="font-size: small;" class="mycode_size">Access de bir tablom var. 3 kolondan oluşuyor. 17 sayısını sql ile min ile max değer arasında sorgulama yaparak AR kolondaki değeri almak istiyorum</span></span><br />
<br />
<br />
<span style="color: #141414;" class="mycode_color"><span style="font-size: small;" class="mycode_size"><!-- start: postbit_attachments_attachment -->
<br /><!-- start: attachment_icon -->
<img src="https://www.access-sql.com/images/attachtypes/image.gif" title="PNG Image" border="0" alt=".png" />
<!-- end: attachment_icon -->&nbsp;&nbsp;<a href="attachment.php?aid=24543" target="_blank" title="">Screenshot_5.png</a> (Boyut: 3,08 KB / İndirilme: 7)
<!-- end: postbit_attachments_attachment --></span> </span>]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Sql Hesaplanmış Alan]]></title>
			<link>https://www.access-sql.com/Konu-Sql-Hesaplanmis-Alan</link>
			<pubDate>Mon, 02 Aug 2021 17:37:23 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Sql-Hesaplanmis-Alan</guid>
			<description><![CDATA[erhaba <br />
<br />
altta Union all ile birleştirip pivot tablo hazırladığım sorgum var. bu pivot tablonun sonuna hesaplanmış bir alan eklemek istiyorum. hesaplanan bu sütünda Depolardaki toplam miktardan Sipariş ve Rezerve miktarlarının çıkartılmasını istiyorum. <br />
("Kumas Depo + Mars Depo + Üretim + Mısır Depo") - (Siparis + Rezerve) gibi. <br />
<br />
forumlarda çok aradım ama nasıl ilerleyeceğimi bulamadım. yardımcı olur musunuz? <br />
<br />
<br />
<div class="codeblock"><div class="title">Visual Basic</div><div class="body"><code><pre class="vba" style="font-family:monospace;"><ol><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">Select</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">   <span style="color: #7B927B;">--</span> Erp_OrderReceipt<span style="color: #7B927B;">.</span>CompanyId [Firma]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">   <span style="color: #268bd2; font-weight: bold;">case</span> when Erp_OrderReceipt<span style="color: #7B927B;">.</span>ReceiptType<span style="color: #7B927B;">=</span>2 <span style="color: #268bd2; font-weight: bold;">then</span> <span style="color: #008000;">'Sipariş' end [Depo],</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"> <span style="color: #7B927B;">--</span>   Erp_OrderReceipt<span style="color: #7B927B;">.</span>IsClosed [Kapalı]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory<span style="color: #7B927B;">.</span>InventoryName [Kalite]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>Quantity [Miktar]</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">From</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt Inner Join</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceiptItem <span style="color: #151B8D; font-weight: bold;">On</span> Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>OrderReceiptId <span style="color: #7B927B;">=</span> Erp_OrderReceipt<span style="color: #7B927B;">.</span>RecId Inner Join</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory <span style="color: #151B8D; font-weight: bold;">On</span> Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>InventoryId <span style="color: #7B927B;">=</span> Erp_Inventory<span style="color: #7B927B;">.</span>RecId</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Where</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt<span style="color: #7B927B;">.</span>CompanyId <span style="color: #7B927B;">=</span> 1 <span style="color: #268bd2; font-weight: bold;">And</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt<span style="color: #7B927B;">.</span>ReceiptType <span style="color: #7B927B;">=</span> 2 <span style="color: #268bd2; font-weight: bold;">And</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt<span style="color: #7B927B;">.</span>IsClosed <span style="color: #7B927B;">&lt;&gt;</span> 1</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">union all </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">Select</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">   <span style="color: #7B927B;">--</span> Erp_InventoryReceipt<span style="color: #7B927B;">.</span>CompanyId [Firma]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    <span style="color: #268bd2; font-weight: bold;">case</span> when Erp_InventoryReceipt<span style="color: #7B927B;">.</span>ReceiptType<span style="color: #7B927B;">=</span>160 <span style="color: #268bd2; font-weight: bold;">then</span> <span style="color: #008000;">'Rezerve' end [Depo],</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">--</span>0 <span style="color: #151B8D; font-weight: bold;">as</span> [Kapalı]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory<span style="color: #7B927B;">.</span>InventoryName [Kalite]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_InventoryReceiptItem<span style="color: #7B927B;">.</span>Quantity [Miktar]</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">&nbsp;</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">From</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_InventoryReceipt Inner Join</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_InventoryReceiptItem <span style="color: #151B8D; font-weight: bold;">On</span> Erp_InventoryReceiptItem<span style="color: #7B927B;">.</span>InventoryReceiptId <span style="color: #7B927B;">=</span> Erp_InventoryReceipt<span style="color: #7B927B;">.</span>RecId Inner Join</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory <span style="color: #151B8D; font-weight: bold;">On</span> Erp_InventoryReceiptItem<span style="color: #7B927B;">.</span>InventoryId <span style="color: #7B927B;">=</span> Erp_Inventory<span style="color: #7B927B;">.</span>RecId</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Where</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_InventoryReceipt<span style="color: #7B927B;">.</span>CompanyId <span style="color: #7B927B;">=</span> 1 <span style="color: #268bd2; font-weight: bold;">And</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_InventoryReceipt<span style="color: #7B927B;">.</span>ReceiptType <span style="color: #7B927B;">=</span> 160</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">union all </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">Select</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">   <span style="color: #7B927B;">--</span> Erp_OrderReceipt<span style="color: #7B927B;">.</span>CompanyId [Firma]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    <span style="color: #268bd2; font-weight: bold;">case</span> when Erp_OrderReceipt<span style="color: #7B927B;">.</span>ReceiptType<span style="color: #7B927B;">=</span>1 <span style="color: #268bd2; font-weight: bold;">then</span> <span style="color: #008000;">'Üretim' end  [Depo],</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">--</span>Erp_OrderReceipt<span style="color: #7B927B;">.</span>IsClosed [Kapalı]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory<span style="color: #7B927B;">.</span>InventoryName [Kalite]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>Quantity <span style="color: #7B927B;">-</span> Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>ReceivedQuantity [Miktar]</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">From</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt Inner Join</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceiptItem <span style="color: #151B8D; font-weight: bold;">On</span> Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>OrderReceiptId <span style="color: #7B927B;">=</span> Erp_OrderReceipt<span style="color: #7B927B;">.</span>RecId Inner Join</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory <span style="color: #151B8D; font-weight: bold;">On</span> Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>InventoryId <span style="color: #7B927B;">=</span> Erp_Inventory<span style="color: #7B927B;">.</span>RecId</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Where</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt<span style="color: #7B927B;">.</span>CompanyId <span style="color: #7B927B;">=</span> 1 <span style="color: #268bd2; font-weight: bold;">And</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt<span style="color: #7B927B;">.</span>ReceiptType <span style="color: #7B927B;">=</span> 1 <span style="color: #268bd2; font-weight: bold;">And</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt<span style="color: #7B927B;">.</span>IsClosed <span style="color: #7B927B;">&lt;&gt;</span> 1</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">union all </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">Select</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">--</span>Erp_Warehouse<span style="color: #7B927B;">.</span>CompanyId [Firma]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Erp_Warehouse<span style="color: #7B927B;">.</span>WarehouseName [Depo]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">--</span>0 <span style="color: #151B8D; font-weight: bold;">as</span> [Kapalı]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Erp_Inventory<span style="color: #7B927B;">.</span>InventoryName [Kalite]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Sum<span style="color: #7B927B;">(</span>Erp_InventoryTotal<span style="color: #7B927B;">.</span>ActualStock<span style="color: #7B927B;">)</span> <span style="color: #7B927B;">/</span> 2 [Miktar]    </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">From</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_InventoryTotal Inner Join</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory <span style="color: #151B8D; font-weight: bold;">On</span> Erp_InventoryTotal<span style="color: #7B927B;">.</span>InventoryId <span style="color: #7B927B;">=</span> Erp_Inventory<span style="color: #7B927B;">.</span>RecId Inner Join</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Warehouse <span style="color: #151B8D; font-weight: bold;">On</span> Erp_InventoryTotal<span style="color: #7B927B;">.</span>WarehouseId <span style="color: #7B927B;">=</span> Erp_Warehouse<span style="color: #7B927B;">.</span>RecId</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Where</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Warehouse<span style="color: #7B927B;">.</span>CompanyId <span style="color: #7B927B;">=</span> 1 <span style="color: #268bd2; font-weight: bold;">And</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Warehouse<span style="color: #7B927B;">.</span>WarehouseCode <span style="color: #7B927B;">&lt;&gt;</span> 02</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Group By</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Warehouse<span style="color: #7B927B;">.</span>CompanyId<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Warehouse<span style="color: #7B927B;">.</span>WarehouseCode<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Warehouse<span style="color: #7B927B;">.</span>WarehouseName<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory<span style="color: #7B927B;">.</span>InventoryName</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">&nbsp;</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">&nbsp;</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    <span style="color: #7B927B;">)</span> tablo </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">&nbsp;</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">pivot </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">(</span> sum<span style="color: #7B927B;">(</span>[Miktar]<span style="color: #7B927B;">)</span> <span style="color: #268bd2; font-weight: bold;">for</span> Depo <span style="color: #268bd2; font-weight: bold;">in</span> <span style="color: #7B927B;">(</span> [Üretim]<span style="color: #7B927B;">,</span> [Kumaş Depo] <span style="color: #7B927B;">,</span> [Mars Antrepo]<span style="color: #7B927B;">,</span> [Yolda<span style="color: #7B927B;">/</span>Gemide]<span style="color: #7B927B;">,</span> [Banglades Liman]<span style="color: #7B927B;">,</span>[Mısır Liman]<span style="color: #7B927B;">,</span> [Mars Yerli]<span style="color: #7B927B;">,</span>[Sipariş]<span style="color: #7B927B;">,</span>[Rezerve]<span style="color: #7B927B;">))</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">pivottablo;</div></li></ol></pre></code></div></div><br /><br />
<br /><!-- start: postbit_attachments_attachment -->
<br /><!-- start: attachment_icon -->
<img src="https://www.access-sql.com/images/attachtypes/image.gif" title="JPEG Image" border="0" alt=".jpg" />
<!-- end: attachment_icon -->&nbsp;&nbsp;<a href="attachment.php?aid=24473" target="_blank" title="">pivot.JPG</a> (Boyut: 65,33 KB / İndirilme: 6)
<!-- end: postbit_attachments_attachment -->]]></description>
			<content:encoded><![CDATA[erhaba <br />
<br />
altta Union all ile birleştirip pivot tablo hazırladığım sorgum var. bu pivot tablonun sonuna hesaplanmış bir alan eklemek istiyorum. hesaplanan bu sütünda Depolardaki toplam miktardan Sipariş ve Rezerve miktarlarının çıkartılmasını istiyorum. <br />
("Kumas Depo + Mars Depo + Üretim + Mısır Depo") - (Siparis + Rezerve) gibi. <br />
<br />
forumlarda çok aradım ama nasıl ilerleyeceğimi bulamadım. yardımcı olur musunuz? <br />
<br />
<br />
<div class="codeblock"><div class="title">Visual Basic</div><div class="body"><code><pre class="vba" style="font-family:monospace;"><ol><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">Select</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">   <span style="color: #7B927B;">--</span> Erp_OrderReceipt<span style="color: #7B927B;">.</span>CompanyId [Firma]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">   <span style="color: #268bd2; font-weight: bold;">case</span> when Erp_OrderReceipt<span style="color: #7B927B;">.</span>ReceiptType<span style="color: #7B927B;">=</span>2 <span style="color: #268bd2; font-weight: bold;">then</span> <span style="color: #008000;">'Sipariş' end [Depo],</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"> <span style="color: #7B927B;">--</span>   Erp_OrderReceipt<span style="color: #7B927B;">.</span>IsClosed [Kapalı]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory<span style="color: #7B927B;">.</span>InventoryName [Kalite]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>Quantity [Miktar]</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">From</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt Inner Join</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceiptItem <span style="color: #151B8D; font-weight: bold;">On</span> Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>OrderReceiptId <span style="color: #7B927B;">=</span> Erp_OrderReceipt<span style="color: #7B927B;">.</span>RecId Inner Join</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory <span style="color: #151B8D; font-weight: bold;">On</span> Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>InventoryId <span style="color: #7B927B;">=</span> Erp_Inventory<span style="color: #7B927B;">.</span>RecId</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Where</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt<span style="color: #7B927B;">.</span>CompanyId <span style="color: #7B927B;">=</span> 1 <span style="color: #268bd2; font-weight: bold;">And</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt<span style="color: #7B927B;">.</span>ReceiptType <span style="color: #7B927B;">=</span> 2 <span style="color: #268bd2; font-weight: bold;">And</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt<span style="color: #7B927B;">.</span>IsClosed <span style="color: #7B927B;">&lt;&gt;</span> 1</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">union all </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">Select</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">   <span style="color: #7B927B;">--</span> Erp_InventoryReceipt<span style="color: #7B927B;">.</span>CompanyId [Firma]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    <span style="color: #268bd2; font-weight: bold;">case</span> when Erp_InventoryReceipt<span style="color: #7B927B;">.</span>ReceiptType<span style="color: #7B927B;">=</span>160 <span style="color: #268bd2; font-weight: bold;">then</span> <span style="color: #008000;">'Rezerve' end [Depo],</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">--</span>0 <span style="color: #151B8D; font-weight: bold;">as</span> [Kapalı]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory<span style="color: #7B927B;">.</span>InventoryName [Kalite]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_InventoryReceiptItem<span style="color: #7B927B;">.</span>Quantity [Miktar]</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">&nbsp;</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">From</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_InventoryReceipt Inner Join</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_InventoryReceiptItem <span style="color: #151B8D; font-weight: bold;">On</span> Erp_InventoryReceiptItem<span style="color: #7B927B;">.</span>InventoryReceiptId <span style="color: #7B927B;">=</span> Erp_InventoryReceipt<span style="color: #7B927B;">.</span>RecId Inner Join</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory <span style="color: #151B8D; font-weight: bold;">On</span> Erp_InventoryReceiptItem<span style="color: #7B927B;">.</span>InventoryId <span style="color: #7B927B;">=</span> Erp_Inventory<span style="color: #7B927B;">.</span>RecId</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Where</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_InventoryReceipt<span style="color: #7B927B;">.</span>CompanyId <span style="color: #7B927B;">=</span> 1 <span style="color: #268bd2; font-weight: bold;">And</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_InventoryReceipt<span style="color: #7B927B;">.</span>ReceiptType <span style="color: #7B927B;">=</span> 160</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">union all </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">Select</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">   <span style="color: #7B927B;">--</span> Erp_OrderReceipt<span style="color: #7B927B;">.</span>CompanyId [Firma]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    <span style="color: #268bd2; font-weight: bold;">case</span> when Erp_OrderReceipt<span style="color: #7B927B;">.</span>ReceiptType<span style="color: #7B927B;">=</span>1 <span style="color: #268bd2; font-weight: bold;">then</span> <span style="color: #008000;">'Üretim' end  [Depo],</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">--</span>Erp_OrderReceipt<span style="color: #7B927B;">.</span>IsClosed [Kapalı]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory<span style="color: #7B927B;">.</span>InventoryName [Kalite]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>Quantity <span style="color: #7B927B;">-</span> Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>ReceivedQuantity [Miktar]</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">From</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt Inner Join</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceiptItem <span style="color: #151B8D; font-weight: bold;">On</span> Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>OrderReceiptId <span style="color: #7B927B;">=</span> Erp_OrderReceipt<span style="color: #7B927B;">.</span>RecId Inner Join</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory <span style="color: #151B8D; font-weight: bold;">On</span> Erp_OrderReceiptItem<span style="color: #7B927B;">.</span>InventoryId <span style="color: #7B927B;">=</span> Erp_Inventory<span style="color: #7B927B;">.</span>RecId</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Where</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt<span style="color: #7B927B;">.</span>CompanyId <span style="color: #7B927B;">=</span> 1 <span style="color: #268bd2; font-weight: bold;">And</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt<span style="color: #7B927B;">.</span>ReceiptType <span style="color: #7B927B;">=</span> 1 <span style="color: #268bd2; font-weight: bold;">And</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_OrderReceipt<span style="color: #7B927B;">.</span>IsClosed <span style="color: #7B927B;">&lt;&gt;</span> 1</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">union all </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">Select</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">--</span>Erp_Warehouse<span style="color: #7B927B;">.</span>CompanyId [Firma]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Erp_Warehouse<span style="color: #7B927B;">.</span>WarehouseName [Depo]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">--</span>0 <span style="color: #151B8D; font-weight: bold;">as</span> [Kapalı]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Erp_Inventory<span style="color: #7B927B;">.</span>InventoryName [Kalite]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Sum<span style="color: #7B927B;">(</span>Erp_InventoryTotal<span style="color: #7B927B;">.</span>ActualStock<span style="color: #7B927B;">)</span> <span style="color: #7B927B;">/</span> 2 [Miktar]    </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">  </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">From</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_InventoryTotal Inner Join</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory <span style="color: #151B8D; font-weight: bold;">On</span> Erp_InventoryTotal<span style="color: #7B927B;">.</span>InventoryId <span style="color: #7B927B;">=</span> Erp_Inventory<span style="color: #7B927B;">.</span>RecId Inner Join</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Warehouse <span style="color: #151B8D; font-weight: bold;">On</span> Erp_InventoryTotal<span style="color: #7B927B;">.</span>WarehouseId <span style="color: #7B927B;">=</span> Erp_Warehouse<span style="color: #7B927B;">.</span>RecId</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Where</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Warehouse<span style="color: #7B927B;">.</span>CompanyId <span style="color: #7B927B;">=</span> 1 <span style="color: #268bd2; font-weight: bold;">And</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Warehouse<span style="color: #7B927B;">.</span>WarehouseCode <span style="color: #7B927B;">&lt;&gt;</span> 02</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Group By</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Warehouse<span style="color: #7B927B;">.</span>CompanyId<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Warehouse<span style="color: #7B927B;">.</span>WarehouseCode<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Warehouse<span style="color: #7B927B;">.</span>WarehouseName<span style="color: #7B927B;">,</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    Erp_Inventory<span style="color: #7B927B;">.</span>InventoryName</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">&nbsp;</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">&nbsp;</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">    <span style="color: #7B927B;">)</span> tablo </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">&nbsp;</div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">pivot </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">(</span> sum<span style="color: #7B927B;">(</span>[Miktar]<span style="color: #7B927B;">)</span> <span style="color: #268bd2; font-weight: bold;">for</span> Depo <span style="color: #268bd2; font-weight: bold;">in</span> <span style="color: #7B927B;">(</span> [Üretim]<span style="color: #7B927B;">,</span> [Kumaş Depo] <span style="color: #7B927B;">,</span> [Mars Antrepo]<span style="color: #7B927B;">,</span> [Yolda<span style="color: #7B927B;">/</span>Gemide]<span style="color: #7B927B;">,</span> [Banglades Liman]<span style="color: #7B927B;">,</span>[Mısır Liman]<span style="color: #7B927B;">,</span> [Mars Yerli]<span style="color: #7B927B;">,</span>[Sipariş]<span style="color: #7B927B;">,</span>[Rezerve]<span style="color: #7B927B;">))</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">pivottablo;</div></li></ol></pre></code></div></div><br /><br />
<br /><!-- start: postbit_attachments_attachment -->
<br /><!-- start: attachment_icon -->
<img src="https://www.access-sql.com/images/attachtypes/image.gif" title="JPEG Image" border="0" alt=".jpg" />
<!-- end: attachment_icon -->&nbsp;&nbsp;<a href="attachment.php?aid=24473" target="_blank" title="">pivot.JPG</a> (Boyut: 65,33 KB / İndirilme: 6)
<!-- end: postbit_attachments_attachment -->]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Sqlite Koşullu Sorgu Yazma]]></title>
			<link>https://www.access-sql.com/Konu-Sqlite-Kosullu-Sorgu-Yazma</link>
			<pubDate>Tue, 22 Jun 2021 23:29:02 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Sqlite-Kosullu-Sorgu-Yazma</guid>
			<description><![CDATA[Merhabalar,<br />
<br />
Sqlite de koşullu sorgu yazmam gerekiyor. <br />
<br />
Örnek:<br />
<br />
Elimde 3 Kolon um var.<br />
<br />
1. Kolon (Il)  -  2. Kolon (Neden)  -  3. Kolon (Unsur)<br />
<br />
(((Il)="MANİSA") AND ((Neden)="AG") AND ((Unsur) Not Like"%2 Çıkışı%"))<br />
<br />
Sorgumda Yukarıdaki üç koşul mevcutsa doğru kabul ediyorum ve listede görünmesini istemiyorum. Ama bu 3 koşulu karşılamıyorsa listede görünmesi gerekiyor.<br />
<br />
Yukarıda yazdığım sorguda AND kullanmışım ve işe yaramıyor nerde yanlış yapıyorum bulamadım. <br />
<br />
Bildiğim kadarıyla AND Kullanıldığında koşulların tümünün uyuşması gerekiyor. Yanlışsam düzeltin beni<br />
<br />
 Bu konu hakkında yardımcı olabilir misiniz?]]></description>
			<content:encoded><![CDATA[Merhabalar,<br />
<br />
Sqlite de koşullu sorgu yazmam gerekiyor. <br />
<br />
Örnek:<br />
<br />
Elimde 3 Kolon um var.<br />
<br />
1. Kolon (Il)  -  2. Kolon (Neden)  -  3. Kolon (Unsur)<br />
<br />
(((Il)="MANİSA") AND ((Neden)="AG") AND ((Unsur) Not Like"%2 Çıkışı%"))<br />
<br />
Sorgumda Yukarıdaki üç koşul mevcutsa doğru kabul ediyorum ve listede görünmesini istemiyorum. Ama bu 3 koşulu karşılamıyorsa listede görünmesi gerekiyor.<br />
<br />
Yukarıda yazdığım sorguda AND kullanmışım ve işe yaramıyor nerde yanlış yapıyorum bulamadım. <br />
<br />
Bildiğim kadarıyla AND Kullanıldığında koşulların tümünün uyuşması gerekiyor. Yanlışsam düzeltin beni<br />
<br />
 Bu konu hakkında yardımcı olabilir misiniz?]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Sqlite3 Db Browser Saniyeyi Saat, Dakika, Saniye Verisine Dönüştürmek]]></title>
			<link>https://www.access-sql.com/Konu-Sqlite3-Db-Browser-Saniyeyi-Saat-Dakika-Saniye-Verisine-Donusturmek</link>
			<pubDate>Wed, 16 Jun 2021 17:09:36 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Sqlite3-Db-Browser-Saniyeyi-Saat-Dakika-Saniye-Verisine-Donusturmek</guid>
			<description><![CDATA[Merhabalar<br />
<br />
Sqlite de iki tarih arası farkı saniye cinsinden çektim.<br />
<br />
Verileri gönderdiğim arkadaşlar bu veriden birşey anlamıyor.<br />
<br />
Örneğin :  30428 saniyesini  1 Gün 10:21:01 şekline nasıl dönüştüre bilirim yardımcı olabilir misiniz?]]></description>
			<content:encoded><![CDATA[Merhabalar<br />
<br />
Sqlite de iki tarih arası farkı saniye cinsinden çektim.<br />
<br />
Verileri gönderdiğim arkadaşlar bu veriden birşey anlamıyor.<br />
<br />
Örneğin :  30428 saniyesini  1 Gün 10:21:01 şekline nasıl dönüştüre bilirim yardımcı olabilir misiniz?]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Sql Pıvot Table Da Kolon Toplamı Almak]]></title>
			<link>https://www.access-sql.com/Konu-Sql-Pivot-Table-Da-Kolon-Toplami-Almak</link>
			<pubDate>Mon, 14 Jun 2021 13:58:31 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Sql-Pivot-Table-Da-Kolon-Toplami-Almak</guid>
			<description><![CDATA[Merhaba,<br />
<br />
Aşağıdaki sorguda kolon dip toplamı nasıl alabilirim?<br />
<br />
Teşekkürler<br />
<br />
<br />
<div class="codeblock"><div class="title">Visual Basic</div><div class="body"><code><pre class="vba" style="font-family:monospace;"><ol><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">SELECT</span> M<span style="color: #7B927B;">.*,</span>[1]<span style="color: #7B927B;">+</span>[2]<span style="color: #7B927B;">+</span>[3]<span style="color: #7B927B;">+</span>[4]<span style="color: #7B927B;">+</span>[5]<span style="color: #7B927B;">+</span>[6]<span style="color: #7B927B;">+</span>[7]<span style="color: #7B927B;">+</span>[8]<span style="color: #7B927B;">+</span>[9]<span style="color: #7B927B;">+</span>[10]<span style="color: #7B927B;">+</span>[11]<span style="color: #7B927B;">+</span>[12]<span style="color: #151B8D; font-weight: bold;">AS</span> TOPLAM FROM <span style="color: #7B927B;">(</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">SELECT</span> sAciklama <span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[1]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[1]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[2]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[2]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[3]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[3]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[4]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[4]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">ISNULL<span style="color: #7B927B;">(</span>[5]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[5]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[6]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[6]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[7]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[7]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[8]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[8]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">ISNULL<span style="color: #7B927B;">(</span>[9]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[9]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[10]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[10]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[11]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[11]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[12]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[12]  </div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">FROM<span style="color: #7B927B;">(</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">SELECT</span> sAciklama <span style="color: #7B927B;">,</span>SUM<span style="color: #7B927B;">(</span>[lBrutTutar]<span style="color: #7B927B;">-</span>[lIskontoTutari]<span style="color: #7B927B;">)</span> <span style="color: #151B8D; font-weight: bold;">as</span> Tutar<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">MONTH<span style="color: #7B927B;">(</span>[dteIslemTarihi]<span style="color: #7B927B;">)</span> <span style="color: #151B8D; font-weight: bold;">as</span> AY<span style="color: #7B927B;">,</span> YEAR<span style="color: #7B927B;">(</span>[dteIslemTarihi]<span style="color: #7B927B;">)</span><span style="color: #151B8D; font-weight: bold;">AS</span> YIL </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">FROM TABLO </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">WHERE sFisTipi <span style="color: #7B927B;">=</span> <span style="color: #008000;">'P' AND YEAR([dteIslemTarihi]) = @YEAR</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Group by sAciklama<span style="color: #7B927B;">,</span>[dteIslemTarihi]</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">)</span><span style="color: #151B8D; font-weight: bold;">as</span> TABLO</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">PIVOT </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">(</span>SUM<span style="color: #7B927B;">(</span>Tutar<span style="color: #7B927B;">)</span><span style="color: #268bd2; font-weight: bold;">FOR</span> AY <span style="color: #268bd2; font-weight: bold;">IN</span><span style="color: #7B927B;">(</span>[1]<span style="color: #7B927B;">,</span>[2]<span style="color: #7B927B;">,</span>[3]<span style="color: #7B927B;">,</span>[4]<span style="color: #7B927B;">,</span>[5]<span style="color: #7B927B;">,</span>[6]<span style="color: #7B927B;">,</span>[7]<span style="color: #7B927B;">,</span>[8]<span style="color: #7B927B;">,</span>[9]<span style="color: #7B927B;">,</span>[10]<span style="color: #7B927B;">,</span>[11]<span style="color: #7B927B;">,</span>[12]<span style="color: #7B927B;">))</span> <span style="color: #151B8D; font-weight: bold;">AS</span> TB</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"> <span style="color: #7B927B;">)</span><span style="color: #151B8D; font-weight: bold;">AS</span> M</div></li></ol></pre></code></div></div><br /><br />
]]></description>
			<content:encoded><![CDATA[Merhaba,<br />
<br />
Aşağıdaki sorguda kolon dip toplamı nasıl alabilirim?<br />
<br />
Teşekkürler<br />
<br />
<br />
<div class="codeblock"><div class="title">Visual Basic</div><div class="body"><code><pre class="vba" style="font-family:monospace;"><ol><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">SELECT</span> M<span style="color: #7B927B;">.*,</span>[1]<span style="color: #7B927B;">+</span>[2]<span style="color: #7B927B;">+</span>[3]<span style="color: #7B927B;">+</span>[4]<span style="color: #7B927B;">+</span>[5]<span style="color: #7B927B;">+</span>[6]<span style="color: #7B927B;">+</span>[7]<span style="color: #7B927B;">+</span>[8]<span style="color: #7B927B;">+</span>[9]<span style="color: #7B927B;">+</span>[10]<span style="color: #7B927B;">+</span>[11]<span style="color: #7B927B;">+</span>[12]<span style="color: #151B8D; font-weight: bold;">AS</span> TOPLAM FROM <span style="color: #7B927B;">(</span> </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">SELECT</span> sAciklama <span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[1]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[1]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[2]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[2]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[3]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[3]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[4]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[4]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">ISNULL<span style="color: #7B927B;">(</span>[5]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[5]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[6]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[6]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[7]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[7]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[8]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[8]<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">ISNULL<span style="color: #7B927B;">(</span>[9]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[9]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[10]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[10]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[11]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[11]<span style="color: #7B927B;">,</span>ISNULL<span style="color: #7B927B;">(</span>[12]<span style="color: #7B927B;">,</span>0<span style="color: #7B927B;">)</span>[12]  </div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">FROM<span style="color: #7B927B;">(</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #268bd2; font-weight: bold;">SELECT</span> sAciklama <span style="color: #7B927B;">,</span>SUM<span style="color: #7B927B;">(</span>[lBrutTutar]<span style="color: #7B927B;">-</span>[lIskontoTutari]<span style="color: #7B927B;">)</span> <span style="color: #151B8D; font-weight: bold;">as</span> Tutar<span style="color: #7B927B;">,</span></div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">MONTH<span style="color: #7B927B;">(</span>[dteIslemTarihi]<span style="color: #7B927B;">)</span> <span style="color: #151B8D; font-weight: bold;">as</span> AY<span style="color: #7B927B;">,</span> YEAR<span style="color: #7B927B;">(</span>[dteIslemTarihi]<span style="color: #7B927B;">)</span><span style="color: #151B8D; font-weight: bold;">AS</span> YIL </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">FROM TABLO </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">WHERE sFisTipi <span style="color: #7B927B;">=</span> <span style="color: #008000;">'P' AND YEAR([dteIslemTarihi]) = @YEAR</span></div></li><li style="font-weight: bold; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">Group by sAciklama<span style="color: #7B927B;">,</span>[dteIslemTarihi]</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">)</span><span style="color: #151B8D; font-weight: bold;">as</span> TABLO</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;">PIVOT </div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"><span style="color: #7B927B;">(</span>SUM<span style="color: #7B927B;">(</span>Tutar<span style="color: #7B927B;">)</span><span style="color: #268bd2; font-weight: bold;">FOR</span> AY <span style="color: #268bd2; font-weight: bold;">IN</span><span style="color: #7B927B;">(</span>[1]<span style="color: #7B927B;">,</span>[2]<span style="color: #7B927B;">,</span>[3]<span style="color: #7B927B;">,</span>[4]<span style="color: #7B927B;">,</span>[5]<span style="color: #7B927B;">,</span>[6]<span style="color: #7B927B;">,</span>[7]<span style="color: #7B927B;">,</span>[8]<span style="color: #7B927B;">,</span>[9]<span style="color: #7B927B;">,</span>[10]<span style="color: #7B927B;">,</span>[11]<span style="color: #7B927B;">,</span>[12]<span style="color: #7B927B;">))</span> <span style="color: #151B8D; font-weight: bold;">AS</span> TB</div></li><li style="font-weight: normal; vertical-align:top;"><div style="font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;"> <span style="color: #7B927B;">)</span><span style="color: #151B8D; font-weight: bold;">AS</span> M</div></li></ol></pre></code></div></div><br /><br />
]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Sqlite Browser Iki Tarih Arası Farkı Saniye Cinsinde Almak]]></title>
			<link>https://www.access-sql.com/Konu-Sqlite-Browser-Iki-Tarih-Arasi-Farki-Saniye-Cinsinde-Almak</link>
			<pubDate>Sat, 15 May 2021 15:41:28 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Sqlite-Browser-Iki-Tarih-Arasi-Farki-Saniye-Cinsinde-Almak</guid>
			<description><![CDATA[Merhabalar<br />
<br />
SQLite Browser de iki tarih arası farkı almaya çalışıyorum ama bir türlü başaramadım.<br />
<br />
Bu konu hakkında yardımcı olabilir misiniz?<br />
<br />
Tarih Type leri TEXT<br />
<br />
strftime("%s","UstlenmeTarihi") - strftime("%s","OlusturmaTarihi") bu kodu denedim bi sonuç alamadım hatada vermiyor.]]></description>
			<content:encoded><![CDATA[Merhabalar<br />
<br />
SQLite Browser de iki tarih arası farkı almaya çalışıyorum ama bir türlü başaramadım.<br />
<br />
Bu konu hakkında yardımcı olabilir misiniz?<br />
<br />
Tarih Type leri TEXT<br />
<br />
strftime("%s","UstlenmeTarihi") - strftime("%s","OlusturmaTarihi") bu kodu denedim bi sonuç alamadım hatada vermiyor.]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Sqlite Datetime Den Date Verisini çekme]]></title>
			<link>https://www.access-sql.com/Konu-Sqlite-Datetime-Den-Date-Verisini-cekme</link>
			<pubDate>Fri, 14 May 2021 11:28:43 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Sqlite-Datetime-Den-Date-Verisini-cekme</guid>
			<description><![CDATA[Merhabalar<br />
<br />
OlusmaTarihi (14.05.2021 12:02:00) veriden sadece tarih kısmını çekmeye çalışıyorum bir türlü başaramadım.<br />
<br />
Bu konuda yardımcı olabilir misiniz?<br />
<br />
Sqlite3 Browser kullanıyorum<br />
<br />
Date(OlusmaTarihi) yazarak çekmeye çalışıyorum çekmiyor ve hatada vermiyor.]]></description>
			<content:encoded><![CDATA[Merhabalar<br />
<br />
OlusmaTarihi (14.05.2021 12:02:00) veriden sadece tarih kısmını çekmeye çalışıyorum bir türlü başaramadım.<br />
<br />
Bu konuda yardımcı olabilir misiniz?<br />
<br />
Sqlite3 Browser kullanıyorum<br />
<br />
Date(OlusmaTarihi) yazarak çekmeye çalışıyorum çekmiyor ve hatada vermiyor.]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Where Ile Case When Kullanımı]]></title>
			<link>https://www.access-sql.com/Konu-Where-Ile-Case-When-Kullanimi</link>
			<pubDate>Tue, 09 Mar 2021 20:52:09 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Where-Ile-Case-When-Kullanimi</guid>
			<description><![CDATA[Merhaba,<br />
<br />
Aşağıda istediğim sorguyu elimden geldiğin anlatmaya çalıştım.<br />
Toplam satırlarını açıklayıcı olması açısından yazdım böyle bir satır tabloda yoktur.<br />
Toplanan verileri koyu renk ile işaretledim. (ekli dosya)<br />
<br />
Eğer z sütununda ki aynı tip verilerin (c-d) toplamları 0 a eşit değil ise e sütununda İST içermeyenlerin (a-b)lerini topla<br />
0 ise tüm satırların (a-b)lerini topla<br />
<br />
Cevap <br />
<br />
<span style="font-weight: bold;" class="mycode_b">ELMA    -33  </span> (18 - 51) elmaların sum(c-d)si 35-35 =0 olduğu için tüm elmalar için (a-b) toplamlarını aldı<br />
<span style="font-weight: bold;" class="mycode_b">ARMUT </span><span style="font-weight: bold;" class="mycode_b">-25 </span>(6 - 31) armutun (c-d) sütünlarının toplamı (40-35) 0 a eşit olmadığı için sadece ANT olanları (a-b) sütünlarını topladı<br /><!-- start: postbit_attachments_attachment -->
<br /><!-- start: attachment_icon -->
<img src="https://www.access-sql.com/images/attachtypes/image.gif" title="PNG Image" border="0" alt=".png" />
<!-- end: attachment_icon -->&nbsp;&nbsp;<a href="attachment.php?aid=24120" target="_blank" title="">Ekran Alıntısı.PNG</a> (Boyut: 12,61 KB / İndirilme: 19)
<!-- end: postbit_attachments_attachment -->]]></description>
			<content:encoded><![CDATA[Merhaba,<br />
<br />
Aşağıda istediğim sorguyu elimden geldiğin anlatmaya çalıştım.<br />
Toplam satırlarını açıklayıcı olması açısından yazdım böyle bir satır tabloda yoktur.<br />
Toplanan verileri koyu renk ile işaretledim. (ekli dosya)<br />
<br />
Eğer z sütununda ki aynı tip verilerin (c-d) toplamları 0 a eşit değil ise e sütununda İST içermeyenlerin (a-b)lerini topla<br />
0 ise tüm satırların (a-b)lerini topla<br />
<br />
Cevap <br />
<br />
<span style="font-weight: bold;" class="mycode_b">ELMA    -33  </span> (18 - 51) elmaların sum(c-d)si 35-35 =0 olduğu için tüm elmalar için (a-b) toplamlarını aldı<br />
<span style="font-weight: bold;" class="mycode_b">ARMUT </span><span style="font-weight: bold;" class="mycode_b">-25 </span>(6 - 31) armutun (c-d) sütünlarının toplamı (40-35) 0 a eşit olmadığı için sadece ANT olanları (a-b) sütünlarını topladı<br /><!-- start: postbit_attachments_attachment -->
<br /><!-- start: attachment_icon -->
<img src="https://www.access-sql.com/images/attachtypes/image.gif" title="PNG Image" border="0" alt=".png" />
<!-- end: attachment_icon -->&nbsp;&nbsp;<a href="attachment.php?aid=24120" target="_blank" title="">Ekran Alıntısı.PNG</a> (Boyut: 12,61 KB / İndirilme: 19)
<!-- end: postbit_attachments_attachment -->]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Sql E-r Diyagramı]]></title>
			<link>https://www.access-sql.com/Konu-Sql-E-r-Diyagrami</link>
			<pubDate>Thu, 21 Jan 2021 01:28:12 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Sql-E-r-Diyagrami</guid>
			<description><![CDATA[<span style="color: #d8cdbd;" class="mycode_color"><span style="font-size: medium;" class="mycode_size"><span style="font-family: Arial, Helvetica, sans-serif;" class="mycode_font"><span style="font-style: italic;" class="mycode_i"><span style="font-weight: bold;" class="mycode_b">Merhaba, ödevim için e-r diyagramı hazırlamam gerekiyor. Projede 28 tablo olduğu için karıştırıp, bağlantıları kuramadım.</span></span></span></span></span><br />
<span style="color: #d8cdbd;" class="mycode_color"><span style="font-size: medium;" class="mycode_size"><span style="font-family: Arial, Helvetica, sans-serif;" class="mycode_font"><span style="font-style: italic;" class="mycode_i"><span style="font-weight: bold;" class="mycode_b">Yardım ederseniz çok sevinirim. Teşekkür ederim.</span></span></span></span></span><br />
<br />
<span style="font-style: italic;" class="mycode_i"><span style="color: #d8cdbd;" class="mycode_color"><span style="font-size: medium;" class="mycode_size"><span style="font-family: Arial, Helvetica, sans-serif;" class="mycode_font"><span style="font-weight: bold;" class="mycode_b"><span style="color: #ff7555;" class="mycode_color"><a href="https://1drv.ms/u/s!Apuuoh_UXTMFgYZd-beIA5P9TzcNog" target="_blank" rel="noopener" class="mycode_url">https://1drv.ms/u/s!Apuuoh_UXTMFgYZd-beIA5P9TzcNog</a></span></span></span></span></span></span><br /><!-- start: postbit_attachments_attachment -->
<br /><!-- start: attachment_icon -->
<img src="https://www.access-sql.com/images/attachtypes/image.gif" title="JPEG Image" border="0" alt=".jpg" />
<!-- end: attachment_icon -->&nbsp;&nbsp;<a href="attachment.php?aid=23974" target="_blank" title="">Hastane E-R Diyagram mm.jpg</a> (Boyut: 342,55 KB / İndirilme: 14)
<!-- end: postbit_attachments_attachment -->]]></description>
			<content:encoded><![CDATA[<span style="color: #d8cdbd;" class="mycode_color"><span style="font-size: medium;" class="mycode_size"><span style="font-family: Arial, Helvetica, sans-serif;" class="mycode_font"><span style="font-style: italic;" class="mycode_i"><span style="font-weight: bold;" class="mycode_b">Merhaba, ödevim için e-r diyagramı hazırlamam gerekiyor. Projede 28 tablo olduğu için karıştırıp, bağlantıları kuramadım.</span></span></span></span></span><br />
<span style="color: #d8cdbd;" class="mycode_color"><span style="font-size: medium;" class="mycode_size"><span style="font-family: Arial, Helvetica, sans-serif;" class="mycode_font"><span style="font-style: italic;" class="mycode_i"><span style="font-weight: bold;" class="mycode_b">Yardım ederseniz çok sevinirim. Teşekkür ederim.</span></span></span></span></span><br />
<br />
<span style="font-style: italic;" class="mycode_i"><span style="color: #d8cdbd;" class="mycode_color"><span style="font-size: medium;" class="mycode_size"><span style="font-family: Arial, Helvetica, sans-serif;" class="mycode_font"><span style="font-weight: bold;" class="mycode_b"><span style="color: #ff7555;" class="mycode_color"><a href="https://1drv.ms/u/s!Apuuoh_UXTMFgYZd-beIA5P9TzcNog" target="_blank" rel="noopener" class="mycode_url">https://1drv.ms/u/s!Apuuoh_UXTMFgYZd-beIA5P9TzcNog</a></span></span></span></span></span></span><br /><!-- start: postbit_attachments_attachment -->
<br /><!-- start: attachment_icon -->
<img src="https://www.access-sql.com/images/attachtypes/image.gif" title="JPEG Image" border="0" alt=".jpg" />
<!-- end: attachment_icon -->&nbsp;&nbsp;<a href="attachment.php?aid=23974" target="_blank" title="">Hastane E-R Diyagram mm.jpg</a> (Boyut: 342,55 KB / İndirilme: 14)
<!-- end: postbit_attachments_attachment -->]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[C# Ile Sql'de Ilişkili Tabloya Veri Ekleme]]></title>
			<link>https://www.access-sql.com/Konu-C-Ile-Sql-de-Iliskili-Tabloya-Veri-Ekleme</link>
			<pubDate>Wed, 16 Dec 2020 16:17:07 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-C-Ile-Sql-de-Iliskili-Tabloya-Veri-Ekleme</guid>
			<description><![CDATA[Merhaba arkadaşlar. Ben c#'da basit bir oyun yapıyorum. Bir konuda yardımınıza ihtiyacım var.<br />
<br />
Sql'de iki tane tablo mevcut. <br />
Birisi "kullanıcı" tablosu. Burada "id", "kullanıcı adı" ve "şifre" alanları var.<br />
Diğeri "skor" tablosu. Burada kullanıcı tablosundaki "id" alanı ile ilişkili olan bir "kullanıcı id" alanı ve ilişkisiz bir "skor" alanı var.<br />
Amacım kullanıcı oyuna giriş yapıp oyununu oynayıp bir puan kazandıktan sonra elde ettiği puanı "skor" tablosuna giriş yapan kişinin "kullanıcı  id"si ile beraber kaydetmek. Öncelikle yapmak istediğim olay bu. <br />
Daha sonraki aşamada da "skor" tablosundaki verilerin hepsini form üzerinde listelemek istiyorum. Tabi skor tablosundaki ilişkili olan "kullanıcı id"  alanındaki veriye göre "kullanıcı" tablosundan ilişkili olduğu kullanıcının ismini yani "kullanıcı adı" alanını göstererek yapmak istiyorum bunu.<br />
Yardımcı olursanız sevinirim, teşekkürler.]]></description>
			<content:encoded><![CDATA[Merhaba arkadaşlar. Ben c#'da basit bir oyun yapıyorum. Bir konuda yardımınıza ihtiyacım var.<br />
<br />
Sql'de iki tane tablo mevcut. <br />
Birisi "kullanıcı" tablosu. Burada "id", "kullanıcı adı" ve "şifre" alanları var.<br />
Diğeri "skor" tablosu. Burada kullanıcı tablosundaki "id" alanı ile ilişkili olan bir "kullanıcı id" alanı ve ilişkisiz bir "skor" alanı var.<br />
Amacım kullanıcı oyuna giriş yapıp oyununu oynayıp bir puan kazandıktan sonra elde ettiği puanı "skor" tablosuna giriş yapan kişinin "kullanıcı  id"si ile beraber kaydetmek. Öncelikle yapmak istediğim olay bu. <br />
Daha sonraki aşamada da "skor" tablosundaki verilerin hepsini form üzerinde listelemek istiyorum. Tabi skor tablosundaki ilişkili olan "kullanıcı id"  alanındaki veriye göre "kullanıcı" tablosundan ilişkili olduğu kullanıcının ismini yani "kullanıcı adı" alanını göstererek yapmak istiyorum bunu.<br />
Yardımcı olursanız sevinirim, teşekkürler.]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Sql Listeleme Yaparken Mükerrer Kayıtlarda Denden Kullanma]]></title>
			<link>https://www.access-sql.com/Konu-Sql-Listeleme-Yaparken-Mukerrer-Kayitlarda-Denden-Kullanma</link>
			<pubDate>Tue, 13 Oct 2020 11:29:08 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Sql-Listeleme-Yaparken-Mukerrer-Kayitlarda-Denden-Kullanma</guid>
			<description><![CDATA[Mssql server ile select ile gerekli alanları seçip listeleme yaparken aynı isimleri denden ile nasıl gösterebiliriz<br />
<br />
Örnek<br />
Ahmet<br />
" " "<br />
" " "<br />
Mehmet<br />
Ali<br />
" " "<br />
" " "]]></description>
			<content:encoded><![CDATA[Mssql server ile select ile gerekli alanları seçip listeleme yaparken aynı isimleri denden ile nasıl gösterebiliriz<br />
<br />
Örnek<br />
Ahmet<br />
" " "<br />
" " "<br />
Mehmet<br />
Ali<br />
" " "<br />
" " "]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Sql Tablosuna Veri Kopyalama]]></title>
			<link>https://www.access-sql.com/Konu-Sql-Tablosuna-Veri-Kopyalama</link>
			<pubDate>Fri, 09 Oct 2020 11:40:28 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Sql-Tablosuna-Veri-Kopyalama</guid>
			<description><![CDATA[YARDIM EDİN İŞTEN ATILACAĞIM<br />
45 Yaşında C# ile kodlamaya merak saldım. Bi depo programı yapmaya çalışıyorum. Excell de malzeme adları var. Onları SQL in tablosuna (kolona) aktarmak istiyorum. excell de ctrl+c yapıp sql de ctrl+v yaptığımda sütunda tek hücreye yapıştırıyor. Bunları alt alta nasıl yapıştırabilirim lütfen siz bilgi sahipleri benimle paylaşır mısınız ? Siz yetkili bi abiye benziyosunuz... <img src="https://www.access-sql.com/images/smilies/sml2/hh.gif" alt="Hh" title="Hh" class="smilie smilie_190" />]]></description>
			<content:encoded><![CDATA[YARDIM EDİN İŞTEN ATILACAĞIM<br />
45 Yaşında C# ile kodlamaya merak saldım. Bi depo programı yapmaya çalışıyorum. Excell de malzeme adları var. Onları SQL in tablosuna (kolona) aktarmak istiyorum. excell de ctrl+c yapıp sql de ctrl+v yaptığımda sütunda tek hücreye yapıştırıyor. Bunları alt alta nasıl yapıştırabilirim lütfen siz bilgi sahipleri benimle paylaşır mısınız ? Siz yetkili bi abiye benziyosunuz... <img src="https://www.access-sql.com/images/smilies/sml2/hh.gif" alt="Hh" title="Hh" class="smilie smilie_190" />]]></content:encoded>
		</item>
		<item>
			<title><![CDATA[Sql Select Sorgusu Hakk.]]></title>
			<link>https://www.access-sql.com/Konu-Sql-Select-Sorgusu-Hakk</link>
			<pubDate>Tue, 23 Jun 2020 13:41:33 +0300</pubDate>
			<guid isPermaLink="false">https://www.access-sql.com/Konu-Sql-Select-Sorgusu-Hakk</guid>
			<description><![CDATA[<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">Merhaba,</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">SQL'de bir tablodan aşağıdaki gibi bir sorgu ile veri çekiyorum.</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">(.....................</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">from FY2020</span></span></span><br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">where</span></span></span><br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">[Item name] like 'AFF%'</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">order by [Item name])</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">AFF ile başlayan bütün ürünleri listeliyor.</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">Benim yapmak istediğim yeni sorguda @AFF ile başlasın fakat @-d ile bitenler bulunmasın.</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">@AFF ve @-d değişlik gösterebiliyor.AFF özelinde bütün ürünleri yazabilirim fakat mümkün değil.Çok fazla ürün var.</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">bu sorgu nasıl yazabilirim bilen varsa yardımcı olabilir mi ?</span></span></span>]]></description>
			<content:encoded><![CDATA[<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">Merhaba,</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">SQL'de bir tablodan aşağıdaki gibi bir sorgu ile veri çekiyorum.</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">(.....................</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">from FY2020</span></span></span><br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">where</span></span></span><br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">[Item name] like 'AFF%'</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">order by [Item name])</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">AFF ile başlayan bütün ürünleri listeliyor.</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">Benim yapmak istediğim yeni sorguda @AFF ile başlasın fakat @-d ile bitenler bulunmasın.</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">@AFF ve @-d değişlik gösterebiliyor.AFF özelinde bütün ürünleri yazabilirim fakat mümkün değil.Çok fazla ürün var.</span></span></span><br />
<br />
<span style="color: #000000;" class="mycode_color"><span style="font-size: x-small;" class="mycode_size"><span style="font-family: verdana;" class="mycode_font">bu sorgu nasıl yazabilirim bilen varsa yardımcı olabilir mi ?</span></span></span>]]></content:encoded>
		</item>
	</channel>
</rss>