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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only