Search results

  1. K

    Group Mulitple Data Ranges by ID and Plan Code

    I would like to see each employee ID and the latest date range (latest stop date) for each plan code. An employee can have more than one plan code. I've attached what I would like the end result to look like.
  2. K

    Group Mulitple Data Ranges by ID and Plan Code

    Hello, I have a file of multiple data ranges per EEID ranging from 1/1/2003 to current. The various stop/start dates is how they appear in our HRIS. I am looking for suggestions of code to group by EEID and plan code. I have the spreadsheet attached void of any confidential data. It was...
  3. K

    Hello! Let Me Introduce Myself

    Hello, My name is Karen Roe, and I am a beginning programmer. I am trying to expand my knowledge of SQL to successfully run more advanced queries. I am a team leader in the maintenance of the benefits module of our Human Resource Information System at Virginia Beach City Public Schools in...
Top Bottom