Yeah, I guess it would make sense to include some links to the PERCENTILE_CONT help doc's. Sorry about that!!

http://www.java2s.com/Tutorial/Oracle/0320__Analytical-Functions/0420__PERCENTILE_CONT.htm

http://www.acs.ilstu.edu/docs/Oracle/server.101/b10759/functions100.htm

Thanks again,

Dave

Below is the table create script and insert stmt's. that the query is based on.

Also, the oracle query and result set are below.

--ORACLE QUERY

SELECT DISTINCT CD_RSPNS, TX_RSPNS,

sum(DECODE(FIRST_RPT_FOR_INVS,'Yes',1,0)) OVER...

SQL Native Client driver version 2005.90.3042.00.

All of it looks good, but I'm lost within the following code, specifically the line starting with "with leader...". I've been working w/SQL for 12+ years and I've never...