Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Getting Most Recent Date Records

    This CTE/Query seems to be giving me the reults I am looking for. Thank you for your assitance and guidance.

    With HR_CTE (seq, EmployeeId, Name, Department, JobTitle, EffectiveDate, SocSecNbr, Address, City,...

    December 8, 2011 at 8:20 am

    #1418704

  • RE: Getting Most Recent Date Records

    Evil Kraig F (12/7/2011)

    SQLRNNR (12/7/2011)

    try using a cte and a row_number() ranking function.

    Put your query in the cte with that ranking function, then select from the cte where rownum=1

    I would...

    December 8, 2011 at 7:39 am

    #1418685

  • RE: Getting Most Recent Date Records

    Burninator (12/7/2011)

    If you are looking just to find the max effective date for each person and type of job, just use the max and group by the rest:

    SELECT DISTINCT

    ...

    December 8, 2011 at 7:21 am

    #1418677

  • RE: Getting Most Recent Date Records

    Thanks for the advice.

    I have never used a CTE, so I will research their use and hash it out to see if I can get it working that way.

    December 7, 2011 at 1:07 pm

    #1418348

Viewing 4 posts - 1 through 4 (of 4 total)