日期:2014-05-18 浏览次数:20719 次
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]