27,579
社区成员
发帖
与我相关
我的任务
分享
只看到一个表, 也上传不了太多数据, 你先用着吧。
SET IDENTITY_INSERT Factcallcenter ON
--set nocount on select 'insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values('as '--',[FactCallCenterID],',',[DateKey],',','N'''+rtrim([WageType])+'''',',','N'''+rtrim([Shift])+'''',',',[LevelOneOperators],',',[LevelTwoOperators],',',[TotalOperators],',',[Calls],',',[AutomaticResponses],',',[Orders],',',[IssuesRaised],',',[AverageTimePerIssue],',',[ServiceGrade],')' from Factcallcenter
-- FactCallCenterID DateKey LevelOneOperators LevelTwoOperators TotalOperators Calls AutomaticResponses Orders IssuesRaised AverageTimePerIssue ServiceGrade
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------- ---- ----------- ---- ------------------ ---- ----------------------- ---- ----------------- ---- ----------------- ---- -------------- ---- ----------- ---- ------------------ ---- ----------- ---- ------------ ---- ------------------- ---- ---------------------- ----
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 1 , 20101101 , N'weekday' , N'AM' , 2 , 7 , 9 , 405 , 283 , 341 , 2 , 79 , 0.03 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 2 , 20101101 , N'weekday' , N'PM1' , 2 , 10 , 12 , 389 , 256 , 251 , 1 , 94 , 0.12 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 3 , 20101101 , N'weekday' , N'PM2' , 3 , 11 , 14 , 358 , 268 , 255 , 1 , 92 , 0.14 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 4 , 20101101 , N'weekday' , N'midnight' , 1 , 4 , 5 , 219 , 140 , 162 , 2 , 73 , 0.08 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 5 , 20101102 , N'weekday' , N'AM' , 2 , 8 , 10 , 264 , 170 , 189 , 1 , 58 , 0.09 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 6 , 20101102 , N'weekday' , N'PM1' , 3 , 10 , 13 , 539 , 338 , 381 , 1 , 83 , 0.08 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 7 , 20101102 , N'weekday' , N'PM2' , 3 , 12 , 15 , 469 , 308 , 307 , 2 , 85 , 0.16 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 8 , 20101102 , N'weekday' , N'midnight' , 1 , 3 , 4 , 178 , 116 , 136 , 2 , 68 , 0.04 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 9 , 20101103 , N'holiday' , N'AM' , 2 , 8 , 10 , 416 , 279 , 274 , 1 , 84 , 0.12 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 10 , 20101103 , N'holiday' , N'PM1' , 3 , 9 , 12 , 407 , 229 , 266 , 0 , 79 , 0.1 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 11 , 20101103 , N'holiday' , N'PM2' , 3 , 10 , 13 , 290 , 211 , 178 , 1 , 70 , 0.16 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 12 , 20101103 , N'holiday' , N'midnight' , 1 , 4 , 5 , 223 , 96 , 130 , 2 , 76 , 0.13 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 13 , 20101104 , N'holiday' , N'AM' , 2 , 8 , 10 , 376 , 262 , 265 , 2 , 64 , 0.1 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 14 , 20101104 , N'holiday' , N'PM1' , 3 , 10 , 13 , 392 , 231 , 283 , 2 , 70 , 0.06 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 15 , 20101104 , N'holiday' , N'PM2' , 4 , 12 , 16 , 623 , 476 , 427 , 2 , 81 , 0.05 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 16 , 20101104 , N'holiday' , N'midnight' , 1 , 6 , 7 , 225 , 111 , 149 , 2 , 94 , 0.11 )
CREATE TABLE [dbo].[FactCallCenter](
[FactCallCenterID] [int] IDENTITY(1,1) NOT NULL,
[DateKey] [int] NOT NULL,
[WageType] [nvarchar](15) NOT NULL,
[Shift] [nvarchar](20) NOT NULL,
[LevelOneOperators] [smallint] NOT NULL,
[LevelTwoOperators] [smallint] NOT NULL,
[TotalOperators] [smallint] NOT NULL,
[Calls] [int] NOT NULL,
[AutomaticResponses] [int] NOT NULL,
[Orders] [int] NOT NULL,
[IssuesRaised] [smallint] NOT NULL,
[AverageTimePerIssue] [smallint] NOT NULL,
[ServiceGrade] [float] NOT NULL,
CONSTRAINT [PK_FactCallCenter_FactCallCenterID] PRIMARY KEY CLUSTERED
(
[FactCallCenterID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [AK_FactCallCenter_DateKey_Shift] UNIQUE NONCLUSTERED
(
[DateKey] ASC,
[Shift] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FactCallCenter] WITH CHECK ADD CONSTRAINT [FK_FactCallCenter_DimDate] FOREIGN KEY([DateKey])
REFERENCES [dbo].[DimDate] ([DateKey])
GO
ALTER TABLE [dbo].[FactCallCenter] CHECK CONSTRAINT [FK_FactCallCenter_DimDate]
GO
SET IDENTITY_INSERT Factcallcenter ON
--set nocount on select 'insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values('as '--',[FactCallCenterID],',',[DateKey],',','N'''+rtrim([WageType])+'''',',','N'''+rtrim([Shift])+'''',',',[LevelOneOperators],',',[LevelTwoOperators],',',[TotalOperators],',',[Calls],',',[AutomaticResponses],',',[Orders],',',[IssuesRaised],',',[AverageTimePerIssue],',',[ServiceGrade],')' from Factcallcenter
-- FactCallCenterID DateKey LevelOneOperators LevelTwoOperators TotalOperators Calls AutomaticResponses Orders IssuesRaised AverageTimePerIssue ServiceGrade
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------- ---- ----------- ---- ------------------ ---- ----------------------- ---- ----------------- ---- ----------------- ---- -------------- ---- ----------- ---- ------------------ ---- ----------- ---- ------------ ---- ------------------- ---- ---------------------- ----
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 1 , 20101101 , N'weekday' , N'AM' , 2 , 7 , 9 , 405 , 283 , 341 , 2 , 79 , 0.03 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 2 , 20101101 , N'weekday' , N'PM1' , 2 , 10 , 12 , 389 , 256 , 251 , 1 , 94 , 0.12 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 3 , 20101101 , N'weekday' , N'PM2' , 3 , 11 , 14 , 358 , 268 , 255 , 1 , 92 , 0.14 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 4 , 20101101 , N'weekday' , N'midnight' , 1 , 4 , 5 , 219 , 140 , 162 , 2 , 73 , 0.08 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 5 , 20101102 , N'weekday' , N'AM' , 2 , 8 , 10 , 264 , 170 , 189 , 1 , 58 , 0.09 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 6 , 20101102 , N'weekday' , N'PM1' , 3 , 10 , 13 , 539 , 338 , 381 , 1 , 83 , 0.08 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 7 , 20101102 , N'weekday' , N'PM2' , 3 , 12 , 15 , 469 , 308 , 307 , 2 , 85 , 0.16 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 8 , 20101102 , N'weekday' , N'midnight' , 1 , 3 , 4 , 178 , 116 , 136 , 2 , 68 , 0.04 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 9 , 20101103 , N'holiday' , N'AM' , 2 , 8 , 10 , 416 , 279 , 274 , 1 , 84 , 0.12 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 10 , 20101103 , N'holiday' , N'PM1' , 3 , 9 , 12 , 407 , 229 , 266 , 0 , 79 , 0.1 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 11 , 20101103 , N'holiday' , N'PM2' , 3 , 10 , 13 , 290 , 211 , 178 , 1 , 70 , 0.16 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 12 , 20101103 , N'holiday' , N'midnight' , 1 , 4 , 5 , 223 , 96 , 130 , 2 , 76 , 0.13 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 13 , 20101104 , N'holiday' , N'AM' , 2 , 8 , 10 , 376 , 262 , 265 , 2 , 64 , 0.1 )
insert Factcallcenter([FactCallCenterID],[DateKey],[WageType],[Shift],[LevelOneOperators],[LevelTwoOperators],[TotalOperators],[Calls],[AutomaticResponses],[Orders],[IssuesRaised],[AverageTimePerIssue],[ServiceGrade]) values( 14 , 20101104 , N'holiday' , N'PM1' , 3 , 10 , 13 , 392 , 231 , 283 , 2 , 70