Bonnie,

It would be something along the line of the statement below

select genmar_cust.[name] as [Customer Name],hull_id as [Hull ID],model_id as [Boat Model],'1-mo' as [Survey Version],
dbo.datepart(arfregtime) as [Survey Process Date],
case when Q13_22 = 1 then 100 else
case when Q13_22 = 2 then 80 else
case when Q13_22 = 3 then 50 else
case when Q13_22 = 5 then 5 else 0 end end end end as [Overall Satisfaction with Dealer Score] ,
0 as [Overall Satisfaction with Service Score],
0 as [Likelihood to Repurchase from the Same Dealer Score],
case when q14 = 1 then 'Yes' else 'No' end as [Had a Problem],
case when q18 = 1 then 'Yes' else 'No' end as [Customer Wants Dealer to Call Re:Problems from onemonth_rec left