Paul,

Totally do-able, just not with a single SQL statement, like you're used to. <g> You'd just need to code some additional stuff. You're not filtering anything out of this DataTable at all, so I'd suggest just iterating through the rows in the table, replacing things as you go. IOW, your case statements for Q13_22, just use a switch case to replace the column Q13_22 with a 100 if the value is 1, with a 80 if the value is 2, etc. Once you've replaced the values in the columns of the DataTable, then you can display the Table in your Grid.

~~Bonnie




>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