It will just be one table. Basically the client will upload the xml file containing the data to the web server and I need to display it. In addition I will need to do something similar to the query 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