Sitemap

Amicuk Programming Answers

Odd Query behaviour

-0001-11-30   Views:0

Advertisement

Hi Experts, I am experiencing some problems with a query which is designed simply to show whether or not there is data in a single field. SELECT T0.[CardCode], T0.[U_7DayExpiry], T0.[U_LstCRCallStat], T1.[Name] FROM OCRD T0  INNER JOIN [dbo].[@CR_CON

Hi Experts,
I am experiencing some problems with a query which is designed simply to show whether or not there is data in a single field.
SELECT T0.[CardCode], T0.[U_7DayExpiry], T0.[U_LstCRCallStat], T1.[Name] FROM OCRD T0  INNER JOIN [dbo].[@CR_CONTROL_STATUS]  T1 ON T0.U_LstCRCallStat = T1.Code WHERE T0.[U_7DayExpiry] is not null
You can see that there is data from a UDT being pulled into the query.   When I try and run the query with the UDT included I get No Data Was Found....
However, when I removed the UDT from the query:
SELECT T0.[CardCode], T0.[CardName], T0.[U_7DayExpiry] FROM OCRD T0 WHERE T0.[U_7DayExpiry] IS NOT NULL
...I get the correct results.
Why would the addition of the UDT to my query criteria cause this please?
Thanks
Geoff

The replay answer
Advertisement
I reckon its something to do with data from the left table (OCRD.U_LstCRCallStat) not matching up with data from the right (joined) table (@CR_CONTROL_STATUS.Code).
If you make the INNER into a LEFT, do you get any results back?

Go to See the other 4 answers

Odd Query behaviour

Category:DefaultRelease time:-0001-11-30Views:130

Hi Experts, I am experiencing some problems with a query which is designed simply to show whether or not there is data in a single field. SELECT T0.[CardCode], T0.[U_7DayExpiry], T0.[U_LstCRCallStat], T1.[Name] FROM OCRD T0  INNER JOIN [dbo].[@CR_CON[More]

10.6.5 update - 27" iMac, Radeon 5750 odd graphics behaviours?

Category:DefaultRelease time:-0001-11-30Views:130

I updated my new iMac 27" to OS 10.6.5 today and have seen some odd graphics behaviours. 1. Dock icon for Activity Monitor becomes transparent. Running AM, hidden showing CPU history 2. White rectangle at bottom of expanding folder (list view) 3. OK[More]

Odd software behaviour Lumia 720

Category:DefaultRelease time:-0001-11-30Views:130

I'm the proud owner of a Lumia 720 since July. I'm facing some odd software behaviour recently though. Without notice or any pattern, the current app changes to another one, sometimes four or five times while my phone vibrates like mad. It happens tw[More]

Different query behaviour (index or no index use) between sql and pl/sql

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have a query inside a cursor in a procedure, let's say: cursor c_emp (b_dept_no in number) is select * from emp where dept_no = b_dep_no; There is an non unique index on dept_no. In this procedure i first loop through another cursor which g[More]

Odd SocketPermission behaviour

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I've been trying to use SocketPermissions to restrict the IP addresses from which a ServerSocket will accept a connection and am getting some wierd behaviour. The ServerSocket will reject and close the first connection attempt from a disallowed a[More]

Odd Quicklook behaviour

Category:DefaultRelease time:-0001-11-30Views:130

Running mavericks 10.9.2 have noticed a small quirk in the behaviour on one of my installs. Selecting a group of images (mostly jpegs, sometimes tiffs) and opening quicklook. scrollling through and quite randomly some of the images will momentarily f[More]

Odd return behaviour

Category:DefaultRelease time:-0001-11-30Views:130

okay, consider the following example: public class Oops {      public static void main(String args[]){ 1:          String oops; 2:          return; 3:          System.out.println(oops); }we get compile error at 3 saying unreachable statement .. fair[More]

Odd SOAMANAGER behaviour

Category:DefaultRelease time:-0001-11-30Views:130

Ok, I just managed to get my old Dell D610 replaced, but this new laptop has some odd behaviour with some Solman transactions.  I can get into Solman Web Workcenter no problem, but when I try to open SOAMANAGER, I get one blank IE8 window (looks like[More]

Odd JMS Behaviour

Category:DefaultRelease time:-0001-11-30Views:130

With our application deployed to a client, we have been experiencing some odd behaviour with JMS in Oracle 10g (OC4J 9.0.4). The application posts multiple non-transactional messages (roughly 400-500Kb per message) to a queue, which an MDB processes[More]

Really odd module behaviour

Category:DefaultRelease time:-0001-11-30Views:130

This is very strange. First, this works ok: dbxml> setNamespace x http://www.example.com Binding x -> http://www.example.com dbxml> query 'declare function x:foo() as element() {<foo><bar></bar></foo>}; x:foo()' 1 objects[More]

Query Behaviour

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I would like to thank you for your time. I would like your help for the next issue.It is a real problem,but i will presente you like an example. I have a view which is composed as below viewa = sel * from calendar_dim inner join sel * from tab[More]

Hot
Im use to using the diffrent mp3 player's. I was hoping to know if its possible to sync music from Windows Media Player to the Ipod Nano 5th Generation. I tried and my Ipod says no music but its taking up space.You need to use iTunes and add the song [More]
I am having trouble printing across my local network to some printers. This is a mixed wired and wireless LAN.Lan works fine as the windows machines print with no problems. Printing takes place using a Trendnet TE 100-P21 Print Server. This box is co [More]
hi SAP Gurus, I am looking at Capitalization report and on this report I see only 1 Cost there in the report and field called Addition Cost in legacy. Can anyone help me what cost it can be on the capitalization report. It's the only 1 cost listed th [More]
         5508WLC as anchor controller with WLC1 and WLC2 with WCS. I have 2 public ssids set up to go directly to the internet. Everything is working as it should.  I downloaded the web auth bundle from Cisco and  will just use a disclaimer page and [More]
Help!#1 most servers are cAsE sEnSiTiVe.   For best results on the web, use all lower case file and folder names.  #2 rename your folder/file names without any spaces.  White spaces in folder and file names throws validation errors in HTML5 docs.  Wh [More]
Hi all, I am currently working on an application where the user (by d n' d or cut n' paste) should be able to add data to a table. It works fine to add data to the table and display it by using a renderer, but it seems to be impossible to add data to [More]
Hi,   How to run a interactive report in background.I have used job_open,submit and job_close.Here a spool is getting genereated which displays the first o/p but after that in that report based on user selection further processing should happen.How t [More]
Hi everybody, I'm trying to launch accruals and deferrals of comissons related to financing products. I already, IN MONEY MARKET - Created flow type (XXX-Comissions) relevant to acc/defer. - Associated flow type to an update type IN GENERAL SETTINGS [More]
"Could not communicate with your router please try again" Why - if this is supposed to be a premium product why is it so flaky - anyone else had this issue? regards"Could not purchase song. An unknown error occurred (-42408). There was an e [More]
Getting error ORA-01033 : Oracle Initialization or shutdown in progress Tried to login with different users and could login thru one user. when given the command shuddown immediate, gave the error : ORA-01109: database not open Database dismounted. O [More]