Thank you, I'll give that a try

What I need it something like this

DetailName VoteCount (Winner) this is a virtual column

test1 ...

looking at the data the result set appears to be grabbing the emp_ID, and Date and then in the Where clause as well you have a A=1. So I...

Perfect, thank you

I also have the cst_id which is not a number i did that for simplicity it's actually a guid

does that help any.

Matt Wilhoite (10/21/2009)

---

Table definitions and sample data would help but this might get you started.

select * from person P

where numOfYears = (select max(numOfYears) from person P2 where P.cus_key = P2.cus_key)

This...

For the most part that works, but I can't determine the shared datasource name on each report. Any thoughts

Ok, if I use Identity instead of GUID how then when I createing a webform, would I update the 3rd table which just holds the Primary Key's of the other...

Ok let's look at it this way

Candidate table

CandidateID PK

CandidateName field

Position (table)

PositionID Pk

PositionDescription

Candade_Position(table)

CandidateID Comes from CandidateTable

PositionID Comes from PositionTable

If I create a webform that will allow me to put in the...

That seemed to work, I will have to go through some more testing to make sure, but seem things look good at this point.

From my first post when I asked the question the Select statement works after the few minor fixes, I get the exact results I was expecting. However when I...

Ok here is the organizaiton record

SELECT cxa_key, cxa_cst_key , cxa_adr_key, cxa_adt_key, cxa_mail_stop, cxa_on_hold_flag, cxa_on_hold_from, cxa_on_hold_through, cxa_adh_key,

...

Nope, that only updates the single record that already has the cxa_on_hold_flag

It's a little more complex then that, what I need to do is find an organization that has the cxa_on_hold_flag set to 1 and find anyone who has the same...

Well, that did work however it updated every row in the table to set the cxa_on_hold_flag to 1 and not just the subset of data in the select statement