I need a little help. right now I am using a group by query.
[Tax ID], pro_xtyp,[Fee Schedule], [Fee Type]
Where AHS = 'X' and ProductCode ='WCP_IMW' and ST = 'PA' and
[WC and MVA Check] = 'GOOD'
Group by [Tax ID], pro_xtyp,[Fee Schedule], [Fee Type]
order by [Tax ID]
We have a few TaxID that have multiple pro_xtyp or Fees. I woud like to have this rolled up to the TAXID and have a single row. Is this possible? How can I manage to do this?
Here is some of the data that I am looking at.