i have an unorganized table which i am trying to reorgenize
the table consist of 7 columns and about 260,000 records
the records present charges for services rendered.
the relevant columns are: Account Number, Charge Date,Billing code, Billing Description, Billing Amount.
there are about 15 different billing codes.
what i would like to achieve is to write a query that will present all the relevant charges per date for a given account in an horizontal line.
so it will look something like this:
Account Number, Date, Billing Code, Amount, Billing Code, Amount, Billing Code, Amount.....
until all charges for the given date were written.
i have no idea where to start. and am a bit new to sql.
View Complete Post