What I ended up doing just for expediency’s sake is:

In the select:

,'GR' + convert(Varchar,t1.pkRate_Barcodes) 'ac2'

,'GR' + convert(Varchar,t2.pkRate_Barcodes) 'ac26'

,'GR' + convert(Varchar,t3.pkRate_Barcodes) 'GrpRatCont'

,'GR' + convert(Varchar,t4.pkRate_Barcodes) 'EnrollQuest'

,'GR' + convert(Varchar,t5.pkRate_Barcodes) 'EnrollQuestInv'

,'GR' + convert(Varchar,t6.pkRate_Barcodes) 'U-153'

The join:

join Rate_BarCodes t1 on gr.EstExperienceYear = t1.EstExperienceyear

and ge.fkgroup = t1.fkgroup and t1.document_type_name = 'AC-2'

and e.policyno = t1.policyno

join Rate_BarCodes t2 on gr.EstExperienceYear = t2.EstExperienceyear

and ge.fkgroup = t2.fkgroup and t2.document_type_name = 'AC-26'

and e.policyno = t2.policyno

join Rate_BarCodes t3 on gr.EstExperienceYear = t3.EstExperienceyear

and ge.fkgroup = t3.fkgroup and t3.document_type_name = 'GrpRatCont'

and e.policyno = t3.policyno

join Rate_BarCodes t4 on gr.EstExperienceYear = t4.EstExperienceyear

and ge.fkgroup = t4.fkgroup and t4.document_type_name = 'EnrollQuest'

and e.policyno = t4.policyno

join Rate_BarCodes t5 on gr.EstExperienceYear = t5.EstExperienceyear

and ge.fkgroup = t5.fkgroup and t5.document_type_name = 'EnrollQuestInv'

and e.policyno = t5.policyno

join Rate_BarCodes t6 on gr.EstExperienceYear = t6.EstExperienceyear

and ge.fkgroup = t6.fkgroup and t6.document_type_name = 'U-153'

and e.policyno = t6.policyno

I had left out part of the requirements. Each column name from the #NewTable had to have the column name in the select. That is becuase it needs to be exposed to Crystal reports.

I didn't check into cross tabs or pivot.

Thanks to those that replied.