sql server - Getting value twice in SQL -

sql server - Getting value twice in SQL -

After

I have a SQL like this,

  select B. .HESAP_NO, B.TEKLIF_NO1 + '/' + B.TEKLIF_NO2 as 'serious' B.MUS_K_IS I, dbo.fngcod clearance (B.HESAP_NO, B.DOVIZ_KOD, B.TEKLIF_NO1 + '/' + B. TEKLIF_NO2, '11 / 03/2011 ', '11 / 03/2011'), (The case is when B.DOVIZ_KOD = 21 'euro' when B.DOVIZ_KOD = 2 'USD' when B.DOVIZ_KOD = 1 then 'TL 'End') as KUR 'D.AVUKAT (case when in D.HESAP (select T_HESAP_NO by tracking) again (select ICRA_T by tracking where T_HESAP_NO = D.HESAP) and "end" As' ICRA scan ° hame ° (ma When in D.HESAP (select T_HESAP_NO by tracking) then (HACIZ_T by Tracking where T_HESAP_NO = D.HESAP) and 'End' as' Hacaki ° Z scan ° hame YAZ .. MARDATA.S_TEKLIF B, where Associate D ° B.HESAP_NO = D.HESAP and IsNull (dbo.fngcod game (B.HESAP_NO, B.DOVIZ_KOD, B.TEKLIF_NO1 + '/' + B.TEKLIF_NO2, '11 / 03 / 2011 ', '11 / 03/2011'), 0) & gt; 0 Group B.HESAP_NO, B.TEKLIF_NO1 by + '/' + B.TEKLIF_NO2, B.DOVIZ_KOD, B.MUS_K_IS I, D.AVUKAT, D.HESAP    Here is my table ,  
  S_TEKLIF TEKLIF_NO1 (b) follow the counsel HESAP_NO (P) account (P) T_HESAP_NO (P) MUS_K_IS I ICRA_T TEKLIF_NO2 lawyer HACIZ_T here MUS_K_IS I DOVIZ_KOD    is my   function,  
  change function [dbo]. [Fngcod] is (@HESAP INT, @DOV INT, @TEKLIF VARCHAR (10), @BAS up dbo.fngcod VARCHAR (10), @BIT VARCHAR (10)) declared as set back float float @result @ result = (sum (choose amount) Where TEMEL_HESAP YAZ..MARDATA.M_GHAREKET @HESAP and DOVIZ_KOD = = = @DOV and REF_KOD start 'GC' and BACAK_GRUP = 'PERT' and ISL_KOD = like 1 and details' % '+ @TEKLIF +'% 'and ISL_T & gt; = CONVERT (DATETIME +' + + BAS + ', 103) and ISL_T <= CONVERT (DATETIME +' + + BIT + ', 103)) End    Your head  SQL  is working right, but getting two @result returns the value with the same data.  
   
 Where did I make an error can go? After 
    Good luck,   
  Golder    
 
  This is the same,  is not the offer  column is different. You group on that column, so you two will get the result of difference.   

 


  







03:22

















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment







Popular Posts




google chrome extension - Reason for Uncaught Error: Attempting to use
a disconnected port object -



    While retrieving the request from the content script, I get this error in the background page. Does anyone know that this error What can be the reason?   Full stack trace:    Unwanted error: Attempt to use Chrome / Renderer Extension Binding Disconnected Port Objects: 147 Chrome.port Post Message Chrome / Renderer Extension Binings: 147 ChromeHird.port DicePatchOnConnect.Connect Event Chrome / Renderer Extension Binings: 89IExtension.fu SendResponse.state background.js: 1573db.readTransaction.tx.executeSql.paramStr background.js: 1038    This only happens when Reloading extension is not being helpful for a few hours - it is not that after restarting the Chrome browser it will be a solution that becomes normal for a few hours, content script may continue to send requests for background No response can be sent from the background. Is there any way that I can catch this unwanted error and reset the listener?   I am using chrome.extension.onRequest.addListener for my communication. Bef...






visual studio 2010 - How to reinstall MVC 2 tools for VS2010? -



    I uninstalled ASP.Net MVC 2 device for Visual Studio 2010. How can I restore it? MVC2 downloads seem to include only the VS2008 device.   Whatever I said, says that MVC 2 has been included in VS2010, but the installation of an improvement did not fix it, and MVC 2 is not listed. Add VS2010 / Select a component in the Remove screen.      You will get your VS2010ToolsMVC2.msi VS2010 DVD under WCU \ ASPNETMVC - hopefully it will do!    






Git Bash script to check whether repo has any commits? -



    I have a script on which I need to work differently if there is one, which is one or more , Commits. What is the best way to do this?   Something like this will appear in the proxy code.    #! / Bin / bash if [[`git log_count`] ==" 0 "]]; Then there is no commodity for this repo. # What goods ... and echo are "one or more committed!" # What are the other things?    Any ideas?      you can    git rev-parse -verify HEAD    (after :)     This is a pipeline command, and its behavior vs. "  git diff " There is very little possibility to change   I find it more pronounced  rev-parse -verify  means "is this a valid object name?"    This is your  show-ref .  You ask "Is there anything in this safe / head in the safe?"  I ask, "what current  head  exists?"   In practice, both of these are fair tests, because once you have a branch, so to achieve the  HEAD , some mock values will indicate manually lack of editing It is very diffic...








Powered by Blogger