• There is no need to hard-code each payment type in a pivot query. Dynamic SQL can take care of that.