Posted on 2016-08-16
In my SQL DB I have a table 'tblInstallPay_TaxAuthorities'. The pertinent fields in the table are 'InstallPayHdrID' (Int) and 'Parcel' nvarchar(30).
A given InstallPayHDrID may appear multiple times. For a given InstallPayHdrID a Parcel may appear mulltiple times.
I have reporting requirement to list all of the Parcels associated with an InstallPayHdrID on one line.
So if InstallPayHdrID 123 has 3 parcels associated it would show as
123 Parcel1 Parcel2 Parcel3
My initial plan was to write a routine reading a view that groups the InstallPayHDrID and Parcels.
For each ID I would lop thru building a sting of the associated parcels.
I'm wondering if there is a way to create a view that will do this for me. Each returned line in the view would have two fields.
1 The InstallPayHDrID
2. A string of all the parcels associated with that InstallPayHdrID, with each Parcel only being listed once.
Can it be done? If not I'll just go back to my looping routine.