I am neither a health care professional nor particularly healthy, but perhaps I can help. 😛

So you have the above table and another table that contains the charges for each NRV. Nobody has mentioned that you'll need to JOIN above, probably on NRV (but possibly also on Acct#) to the second table of NRV charges.

Then you need to do a SELECT SUM(charges) with a GROUP BY. Whether that GROUP BY is by Acct# or Acct#, NRV or maybe even Acct#, Plan_Code, Patient_type, NRV, I can't tell from your description.

You needn't disclose proprietary data modeling information if you simply obfuscate your table/column names and data, then include only what is needed to give you a proper answer. And then you also should provide expected results.

Be sure to post your DDL and sample data in a consumable format, for example:

CREATE TABLE #Vists

(

Acct# VARCHAR(6)

,Plan_Code VARCHAR(10)

,Patient_type VARCHAR(20)

,NRV INT

);

INSERT INTO #Visits

SELECT '525300','Blue Cross','Outpatient',250

UNION ALL SELECT '525300','Blue Cross','Outpatient',258

UNION ALL SELECT '525300','Blue Cross','Outpatient',300;

Along with the second table that contains your NRV charges.