Recent content by caper11752

Also, I'm noticing that most of my dagent records have values in the incomplete field. Any ideas what this means?

Perhaps a better way to ask this question is how can I reconcile the difference between i_acdtime and acdtime? CMS uses acdtime when calculating Avg ACD Time, but i_acdtime is part of i_stafftime which is really confusing.

Hey folks, I've read the definitions for i_acdtime and acdtime but I'm still a little confused in regards to how they are different. Specifically when looking at the agent tables. ACDTIME The talk time of all ACDCALLS. ACDTIME includes O_ACDTIME but does not include HOLDTIME. This is a...

Hi Folks - I've done quite a bit of searching and have been unable to solve a problem I'm having. I have a list of 200 or so names and scores and need to find the bottom 10 values along with the names associated with them without using any code, only excel functions. There may be duplicate...

Finally got it to work. Thank you both for your input, I really appreciate it!

Ah......that would probably work but it appears that i don't have sufficient privileges to access the sys.tables. Thanks though for the quick response. Are there any other methods that I could use?

Hello, Let's say I have a table called tblMyTable and it has 3 columns, MyId,FirstName,LastName. Is it possible to build a query that would return the column names as row values under a new column? Something like this: MyNewColumnName MyId FirstName LastName I've done plenty of searching...

Anyone? I've searched everywhere and cannot find out what constitutes a HOLDCALL in a skill report, versus a HOLDCALL in an agent report.

Hello, I'm trying to figure out why when I run an agent report vs a skill report that holdcalls are greated on the agent report when compared to the skill report. Any ideas? I've looked at the definition of holdcalls in the cms definitions but it didn't help.

Hey folks, I'm struggling with a query and i'm hoping someone can help me out. I have 3 tables: (1) tblClientGroups  GroupID (PK)  ClientID  GroupName  SortOrder  ReportGrouping  Archived (2)tblGroupJobs  JobID  GroupID  JobName  SortOrder  Archived (3)tblWorkedItems ...

Does anyone know if the values in the Split/Skill Call Profile window are stored in a table in CMS? If so, would you happen to know the name of it?

Hi all - recently our Pipkins server went offline so our RTA feed was unable to send the data over to it. This lasted for 7 days. Now that the Pipkins server is back online, is there any method to recover the RTA data and have it sent via RTA to our Pikpins server?

Hi all, I have a table called tblCodes that looks something like this: Date Code Acct# 1/1/2010 WP41 985744 1/1/2010 WI03 754841 1/1/2010 WP41 545412 1/1/2010 WP41 747477 1/1/2010 WI03 212788 1/2/2010 WI03 124254 1/2/2010 WI03...

Hi all, I need to create a VIEW in SQL 2005 and need some assistance. I'm sure this is possible but it has me stumped. We have a table with several fields, such as Name, StartDate and EndDate. I need the VIEW to return Name, and another field with either True or False in it. So if the...

Hello, I have a massive workbook that is updated daily using Access to export new data. I was wondering how I could go about making an exact copy of my original, except I'd like to replace the formulas with the cell values in the new copy. Then I could distribute the copy to the parties that...