SQL Server CASE 1 WHEN 1, WHERE 1=1 AND 1=1 -


I inherited the following queries from the previous application. I'm having a hard time understanding "selection" and "case" in the "Where" section. 

  SELECT J1.AC_CODE, J1.PERIOD, J1.JRNAL_NO, J1.DESCRIPTN, - J1.AMOUNT, J1.ANAL_T3, Case 1, when 1AJ, which is 1.ACCNT_CODE END, Deo with J1.JRNAL_LINE JSOs J1 where 1 = 1 and 1 = 1 and not ('A' like '% Z%' and J1.JRNAL_SRCE IN ('B / F', 'CLRDN') and J1.JRNAL_NO = 0) and case 1 When 1 'A' is either J.AC_CODE END = 'A' and J1.AC_CODE = '156320' and J1 Differences between 2014 and 2014012 and J1 NALTH3 = 'Analyam' order 1,2, 3,4,5,6,7,8

I'm not sure if I understand the following sections correctly:

First section: 

  issue 1 when 1 then J1.AC_CODE END

through A Gone: If column 1 is true, select literal A or else choose J1. AC_CODE

Second section: 

  where 1 = 1 and 1 = 1 and not ('A' like '% Z%' and J1.JRNAL_SRCE IN ('B / F', 'CLRDN') and J. JRNLLO = 0) and case 1 when the difference between 1A 'A' JACACOCEDEDED = 'A' and J1AAC_Code = '156320' and J1  P> Can you explain this query and write a better version for this whole query? I am running this query on SQL Server 2008 (R2)  
 
 
 
 
 I understand: If the column 1 is correct, then select literal A or else choose J1.AC_CODE.   
 No, this value is being compared to  1  with value  1  and if this is true then the case is a  A  and it is definitely always correct, so the case statement will always return  A . 
 
 Your section does nothing at all. 
 
  1 = 1 and 1 = 1  
 
 will always be true and the case will always be true and '% Z'  Will always be false and this is the whole  and not as 'A' like '% Z%' ....  As always the expression is true. 
 
 A simple version of your query will look like this. 
 
  SELECT J1.AC_CODE, J1.PERIOD, J1.JRNAL_NO, J1.DESCRIPTN, - J1. AMOUNT, J1.ANAL_T3, 'A', J1.JRNAL_LINE to Dbo.JSource J1 WHERE J1.AC_CODE = '156320' and J1. 2014 between 2014001 and 2014012 and J1.ANAL_T3 = 'ANAL001' order 1,2,3,4,5,6,7,8

Comments

Post a Comment

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

I am using Objective-class in my Swift Project through a bridging header. The method signature looks like this: - Some cement (some type) some parameters; I started by getting an example of class, calling method, and storing the value: var myInstance = MyClassWithThatMethod (); Var cfArr = myInstance.someMethod (some value); Then try to get the value in the array: var valueInArrayThatIWant = CFArrayGetValueAtIndex (cfArr, 0); However, I get the error unmanaged & lt; Cfarray & gt; Not like 'CFArray' . Unmanaged & lt; Cfarray & gt; also means? I looked, but I do not need to change the array in a fast array (though it would be good). I need to be able to get value from the array. I also tried CFArray method to pass in a function: func doSomeStuffOnArray (myArray: NSArray) {} Although I get the same error when using: doSomeStuffOnArray (cfArr); // unmanaged & lt; CFArray & gt; I am using CFArray because I want to sto...
Read more

eclipse plugin - Run java code error: Workspace is closed -

To create an automated project, I created a plug-in project with the following dependencies: Org.eclipse.core.resources org.eclipse.equinox.registry org.eclipse.core.runtime and the following The Java class is located in the src folder: Package Examiner; Import org.eclipse.core.resources.IProject; Import org.eclipse.core.resources.IWorkspaceRoot; Import org.eclipse.core.resources.ResourcesPlugin; Import org.eclipse.core.runtime.CoreException; Import org.eclipse.core.runtime.IProgressMonitor; Import org.eclipse.core.runtime.NullProgressMonitor; Public class tes {public static zero main (string [] args) {// TODO auto generated method stub IProgressMonitor progress monitor = new NullProgressMonitor (); IWorkspaceRoot root = ResourcesPlugin.getWorkspace (). GetRoot (); Ipoject project = root.jetproject ("desired projectname"); Try {Project.create (progress monitor); Project.open (progressMonitor); } Grip (CoreException E) {// TODO Auto generated blocking block e....
Read more

c - Error on building source code in VC 6 -

When I create my project in VC6, the BScMKE reports the following error Linking .. Creating Library ... .. / ... / PB / Bean / Debub / ICEERP.Lib and Object ........ P.B. / Bean / DBube / ICREPlay.APP Browse information file ... BSMMK: ​​error can not be read from BK 1505: file '../../PB/bin/TmpOut/ICReplay/Debug/ICReplay_PB.bsc' Error executing bscmake.exe Can someone help me? 2 Reason for reference from: "ICReplay_PB .bsc "file will be corrupted The trunk of the file will be happening with the compiler running out of disk space or is being interrupted when creating .sbr file I think this answer will help you!
Read more