日期:2014-05-18 浏览次数:20709 次
SELECT [Department]
,[#]
,[Created Date]
,[Planned Date]
,[Planned Time]
,[Staff Name]
,[Dealer]
,[Addr# 1]
,[Addr# 2]
,[Model No#]
,[Problem 1]
,[Problem 2]
,[Problem 3]
,[Problem leading to delay]
,[Remarks]
,[Contact]
,[Tel 1]
,[Tel 2]
,[e-mail address]
,[Type]
,[Job status]
,[Job status date]
,[FSO#]
,[Amount]
,[Paid]
,[Quotation#]
,[Warranty Card#]
,[Status]
,[Status_Deadline]
,[Step]
,[Call you in advance]
,[Arrive on time]
,[Identity and Uniform]
,[Satisfied with service]
,[Politeness]
,[Solve the issue]
,[Recommend Johnson Controls]
,[Any comment]
FROM [JCIHKEroom1].[dbo].[temp]