Sad. I don't have access to the crystal ball to divine what a user wants and he thinks I can't help him.

chef423 (1/11/2015)

---

hmmm, that's why I put the output of the above code in the thread...

No worries...Ill figure it out on my own then.

If you don't understand the original code then...

Be sure to post the complete DDL for the table as well.

I have no idea what this is trying to do:

If i_ticket_id1 = i_ticket_id2 and dt_when(i_ticket_id2) > dt_when(i_ticket_id1) and i_ticket_id1(b_cancel = 1) then c_amount1 - c_amount2

No idea what I_ticket_id1 or I_ticket_id2...

But also look at the columns for the sample data and table definition, they don't match.

Mile Higher Than Sea Level (1/11/2015)

---

Thanks! Got the reply Saturday. Came to work downtown Sunday to provide the example data with intended results.

There is a big football game starting soon.

I...

May even be easier than that. I am just waiting for the information I requested.

... Mark one off, 48 days on the calendar to go. 48 days on the calendar to go, 48 days to go, ...

Need three things from you.

1) The schema for the table used in the function - you can limit it to the columns used in the function and any indexed columns...

Based on Jeff's posts and making some assumptions that are not expressed in the original post I have another solution.

Assumptions:

All ID are groups of three

Return those groups that are unique...

Or this (assuming that we know 'T' is the exception) :

WITH TestData as (

SELECT * FROM (VALUES

(1,'a','m')

,(1,'b','n')

...

... Mark one off, 49 days on the calendar to go. 49 days on the calendar to go, 49 days to go, ...

I think it is close enough to the end of my shift to post the following.

Ed Wagner (1/9/2015)

---

Lynn Pettis (1/9/2015)

---

Ed Wagner (1/9/2015)

---

rodjkidd (1/9/2015)

---

Lynn Pettis (1/9/2015)

---

Lynn Pettis (1/9/2015)

---

... Mark one off, 50 days on the calendar to go. 50 days on the calendar to go, 50...

Ed Wagner (1/9/2015)

---

rodjkidd (1/9/2015)

---

Lynn Pettis (1/9/2015)

---

Lynn Pettis (1/9/2015)

---

... Mark one off, 50 days on the calendar to go. 50 days on the calendar to go, 50 days to go, ......