Migrate Call Centre KPI stored procedures, views and tables

assasafras / git_tutorial

Tutorial

0 stars 0 forks source link

Migrate Call Centre KPI stored procedures, views and tables #3

Closed assasafras closed 8 years ago

assasafras commented 8 years ago

All activity occurs within NZReports database on the dbo schema.

[x] Create Table - CCKPI_EndOfDay
[x] Create Table - CCKPI_Targets
[x] (Optional) Fill Tables - CCKPI_Targets and CCKPI_EndOfDay
[x] Create View - vwRHKPIMTD
[x] Create View - vwCallCentreKPIMTD
[x] Create Stored Procedure - sp_CCKPI_DailyTableUpdate

assasafras commented 8 years ago

DEV Deployment Completed.

Step (Optional) Fill Tables - CCKPI_Targets and CCKPI_EndOfDay not run: Error message: Msg 2714, Level 16, State 6, Line 6 "There is already an object named 'CCKPI_EndOfDay' in the database."

assasafras commented 8 years ago

SIT Deployment Completed.

Step (Optional) Fill Tables - CCKPI_Targets and CCKPI_EndOfDay not run: Error message: Msg 2714, Level 16, State 6, Line 6 "There is already an object named 'CCKPI_EndOfDay' in the database."

assasafras commented 8 years ago

UAT Deployment Complete

assasafras commented 8 years ago

assasafras / git_tutorial