SQL Query for CDR

Unanswered Question
Feb 4th, 2010
User Badges:

Any SQL query guru who can help me with this?

The issue is that the process that was set up to gather information regarding CDR’s failed for a couple of weeks and now I am tasked with recovering that data into Equitrac, our time and billing server.  The data gets pulled into the SQL server on the CM1_PUB into the ART database.  From there it gets pulled out into a structure by a program called Facecollate and put into a useable structure for Equitrac. When I look at the authors of the SQL database that would have configured this system I see the following:

- usage EXEC Proc_WeeklyUtilizationOnDemandGen DATETIME INParameter,DATETIME INParameter,NVARCHAR OUTPamrameter

-- INT INParameter,INT OUTPUTParameter,INT OUTPUTParameter

-- drop proc Proc_WeeklyUtilizationOnDemandGen


Name            Proc_WeeklyUtilizationOnDemandGen

Environment     SQL Server 7.0

Functionality   Generate Weekly utilization report

Parameters      Input  : DATETIME - Value of From Date

                                Input  : INT - No Of Days

                Input  : NVARCHAR - Where Condition for the Query

Called Procs    Proc_WeeklyUtilizationBaseOnDemandGen

Assumptions     None

- usage Exec Proc_LoadCdrCmrData IntINParameter IntOutParameter

-- drop proc Proc_LoadCdrCmrData


Name            Proc_LoadCdrCmrData

Environment     SQL Server 7.0

Functionality   Loads CDR and CMR data from CCM database to ART database

Parameters      Input  : Int - Value of load id

                Output : Int - Return value

Called Procs    None

Assumptions     None

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)


This Discussion