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