Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rbcasper

  1. rbcasper

    Need to Capture MIN CLAIM ID - SQL Server

    I need to capture records with the minimum claim ID where provider, diagnosis, and billed amount are the same but claim id and check id are different. EXAMPLE: CLAIM ID DOS PROVIDER DIAGNOSIS BILLED AMOUNT CHECK# 2001 02/05/2011 500 252.5 30.00 35 2015 02/05/2011 500...
  2. rbcasper

    Get Middle Initial from a Name field-SQL Server 2008

    Hi, thank you for your quick response. The code works perfect! Thank you very much. rb
  3. rbcasper

    Get Middle Initial from a Name field-SQL Server 2008

    Hello, I need to extract the middle initial from a name field that contains the last name, comma, and the middle name or initial. There is no space after the comma and, in some cases, there is a space in the last name. Example data: Smith,Jane Ron Dow,John L Ali Welsh,Mary Jane The result I...
  4. rbcasper

    Need to exclude/supress records in CR 2008

    Thank you so very much for your quick and great response! I tried the formula you suggested and it worked. Thanks again. rb
  5. rbcasper

    Need to exclude/supress records in CR 2008

    I need to capture patients who have 2 or more coverages and have at least one Managed Care coverage. I grouped by patient and added a summary of patID. In Select Expert-Group Selection, I entered Count({PATIENT.PAT_ID}, {PATIENT.PAT_NAME}) >= 2. I now have a list of patients who have 2 or more...
See more

Part and Inventory Search

Back
Top