Search results for query: *

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...

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...

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...

I'm fairly new to SSIS and need some help. We have an informix database on another server that I need to connect to. We are trying to connect from a 64-Bit windows 2008 box with SQL 2008. I'm using IBM informix 64-bit ODBC drivers which I've used to setup a System DSN. The DSN is working...

Hello, Recently we purchased a 2008 Windows Server (64-bit) with SQL 2008. We are going to be using this server as a Reporting depository and as such are looking at copying over the CMS databases (dsplit, dvdn, etc.) to SQL 2008. Currently we have CMS 14 and OpenLink 5.2 ODBC client side...

Hi all - I have cms openlink data access drivers installed and am having a slight issue. We have a specific account that we use for connecting and it appears that it is locked on the Solaris box. We had a connection open when our network went down, and now solaris thinks we're still connnected...

We currently have 200 measured skills and need to add more. I know this can be done by modifyling our data storage allocation. I would like to bump it up to 250. Are there any things that I need to consider before bumping this up to 250?

Hi all, Today we noticed that the last 2 items on our Data Storage Allocation form in CMS under Tools, System Setup are displaying incorrectly. The second to last item is displaying as 4000:):) and the last item 2000:):). They should be displaying Number of Exception Records and Number of Call...

I have a Frontpage form that collects several pieces for customer information. This data is saved to a SQL database when the form is submitted. Lately it appears that several records are being entered into the database even though the submit button has only been clicked onece...I've seen up to 5...