Search results for query: *

Hi, I am running Adaptive Server 11.9 moving towards 12.5. I have 2 queries that should give me the same results but are not! Query 1 gives me multiple rows of repetitive output which I do NOT want. The Query 2 gives me the correct output however it is not written in the standard ANSI way...

Hi, I am running Adaptive Server 11.9 moving towards 12.5. I have 2 queries that should give me the same results but are not! Query 1 gives me multiple rows of repetitive output which I do NOT want. The Query 2 gives me the correct output however it is not written in the standard ANSI way...

Hi all, By now you are all tired of seeing me but maybe some day these problems will help others. The following queries were giveing differnt results and I could not see why. Select A.LoanKeyNum,A.PrinBalAmt, B.NMLLoanInvNum ,LoanMsrDte From elmo..LoanMeasure A, elmo..Loan B Where (...

Once again you have helped tremendiouly. Thanks a TON!!! Talk to you guys later.

Hi All, I have some more detail on the ealier Outer Join questions. angiole and rudy, both have helped before I hope they can again. Again I am currently using Sybase Adaptive Server Enterprise 11.9 but moving to 12.5. I have two queries that are supposed to display the same results...

Thanks, you guys were more help then I could have asked for. Again thank you all for your time.

Thanks, you guys were more help then I could have asked for. Agin thank you all for your time.

Thanks, you guys were more help then I could have asked for. Agin thank you all for your time.

Thanks for the help. Yeah I know that is the problem when people write things that seemed to make sense at the time. I will give it a crack and come out with something. Thanks much for the advice.

HI, I am starting a new thread because I need some help with a query. It is for Sybase Adaptive Server Enterprise version 12.5. The situation is that I am running on 11.9 currently and have to migrate code which is old and not ANSI compliant. Following is an example of code which runs fin...

Hi, Yeah I wish I could say what the Having was used for myself. This is the problem with old code that is no longer readable. But as far as I can tell the purposes is to Filter down the results until they get the desired output. I have another example that might be more clear to...

Here are the details. We are running Sybase Adaptive Server Enterprise 11.9. We need to migrate to the new version which is Version 12.5. The new version is more "strict" on using ANSI standards. So we need to make some modifications to our code, especially where we are using some...