473,320 Members | 1,958 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Determine if Linking ID is Set

Let say I have a data table that list a name, ID for the last name, a
field linking it to another table, and a field listing if an optional
LinkStatus. I want to run a check to determine if each last name ID
has a Link to the external ID and exclude ones that have a linkstatus
value. Example:

Name ID LinkedToExtID LinkStatus
Smith, J 1 A24
Smith, H 1
Henry, B 2
Franks, D 3
Franks, E 3 A47
Franks, F 3
Rose, J 4
Rose, L 4
Rose, S 4
Jones, A 5 InProgress
Jones, H 5

Want to run a query returning
ID
2
4
because none of these IDs have a corresponding LinkedToExtID value or
any value in the LinkStatus field. IDs 1 and 3 have a LinkedToExtId
value and ID 5 has a status, so 2 and 4 are the only problems. After
several hours of trying things, I can't seem to get this one.

Any thoughts,
Andrew V. Romero
Jun 27 '08 #1
2 980
On Wed, 30 Apr 2008 15:23:02 -0700 (PDT), "rr*******@icqmail.com"
<rr*******@icqmail.comwrote:

If I understand correctly, you need:
select distinct ID from SomeTable
where LinkedToExtID is null and LinkStatus is null

-Tom.
>Let say I have a data table that list a name, ID for the last name, a
field linking it to another table, and a field listing if an optional
LinkStatus. I want to run a check to determine if each last name ID
has a Link to the external ID and exclude ones that have a linkstatus
value. Example:

Name ID LinkedToExtID LinkStatus
Smith, J 1 A24
Smith, H 1
Henry, B 2
Franks, D 3
Franks, E 3 A47
Franks, F 3
Rose, J 4
Rose, L 4
Rose, S 4
Jones, A 5 InProgress
Jones, H 5

Want to run a query returning
ID
2
4
because none of these IDs have a corresponding LinkedToExtID value or
any value in the LinkStatus field. IDs 1 and 3 have a LinkedToExtId
value and ID 5 has a status, so 2 and 4 are the only problems. After
several hours of trying things, I can't seem to get this one.

Any thoughts,
Andrew V. Romero
Jun 27 '08 #2
On Apr 30, 9:17*pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Wed, 30 Apr 2008 15:23:02 -0700 (PDT), "rrstud...@icqmail.com"

<rrstud...@icqmail.comwrote:

If I understand correctly, you need:
select distinct ID from SomeTable
* where LinkedToExtID is null and LinkStatus is null
Won't select distinct ID where the LinkedToExtId and LinkStatus is
null also return values like ID 3 since there are 2 rows with the ID
of 3 also have null LinkedToExtID and null Linkstatus fields? Since
there is one row with an ID of 3 that has a value in the
LinkedToExtID, I want to exclude it. Only looking for IDs that don't
have a value in the LinkedToExtID or LinkStatus in any of their
records.

Thanks,
Andrew V. Romero

Jun 27 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Wolfgang | last post by:
I have a problem with linking my CPP Code under a irix6 machine (sgi, UNIX). In my CPP code I use some Functions which are written in Python. So its a kind of CPP wrapper for my Python functions In...
0
by: Dibyendu Roy | last post by:
Hi All, I build an object called "dblorcle" to connect to oracle database in Sun solaris box. This is built linking with various oracle ".a" (archived, for static linking) files come with standard...
7
by: Steven T. Hatton | last post by:
Is there anything that gives a good description of how source code is converted into a translation unit, then object code, and then linked. I'm particularly interested in understanding why putting...
20
by: Steven T. Hatton | last post by:
I just read this in the description of how C++ is supposed to be implemented: "All external object and function references are resolved. Library components are linked to satisfy external...
0
by: gasturbtec | last post by:
please help im new at access programming and i just got this project dropped in my lap because the old programmer quit. i've been doing ok so far but now i need to add code to an existing database...
6
by: Rudy Ray Moore | last post by:
I work with a multi-project workspace. One project (the "startup" project) has a "Configuration Type" of "Application (.exe)". The other 40 projects have a "Configuration Type" of "Static Library...
0
by: Rudy Ray Moore | last post by:
I've been having trouble getting incremental linking to work under Visual C++ .net 2003 7.1 for my multi-project workspace. Ronald Laeremans and Carl Daniel (and a few others) helped me figure it...
0
by: Philip Lowman | last post by:
I am in the process of trying to migrate a couple of build solutions to Visual Studio Express 2005 from VS 2003 Professional and I am running into a weird C/C++ runtime library linking issue when...
1
by: srikar | last post by:
what is the difference between static linking & dynamic linking, what are the advantages of each? How to perform static linking & Dynamic linking by using gcc -o liniking will be done , but...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.