Hi all: I'm fairly new to SQL so please bear with me. I have a table in a database with 2.5 years worth of records. I've made a copy of the original table with no data. I would like to create a DTS package that I could schedule once a week to move data from table1 to table2 where records are...
My CMS Error Log is not showing any entries since Nov 29. Usually I have at least the daily archiver messages. Does anyone know why it would stop logging?
I have a CMS designer report and one of the fields is formatted as a number with 2 decimal places, ex. 12.34. However the summary line does not match this format. The summary always displays it a a whole number with no decimals, 12 as an example. Does anyone know why CMS does this or is it by...
I am new to Javascript and need some assistance. We have an application that pushes a web address in the following form to our desktops:
http://myserver/mainpage.asp?class=xxxx where xxxx has 5 possible values.
Based on the value received, I need to redirect to another page, for example:
if...
I have an Excel worksheet that has been developed by a 3rd party. Management wants me to publish it to our Intranet with Interactivity for all to use. My issue is that when I do publish it, one of the formulas contains the YEARFRAC function, which I believe is part of the Analysis TookPak, and...
According to CMS, ti_stafftime = sum(I_ACDTIME + I_ACWTIME + I_DA_ACDTIME + I_DA_ACWTIME + I_RINGTIME + TI_AUXTIME + TI_AVAILTIME + TI_OTHERTIME). Where does hold time figure into this equation?
Does anybody know if there is a way to organize CMS Designer reports? We have quite a few reports for different clients and it's getting to be difficult to find particular report easily.
HI all: I have a page called index.asp with a drop-list box being used to navigate to other pages. Also on this page is a text box called BTN. So when a user makes a selection from the drop-list box and presses GO, I want to pass the value in the BTN text box to the page that was selected and...
Does anyone know what would cause our ANSTIME for a skill to never be below 4 seconds for a given call, even when said call did not have to wait in queue since there were no other calls in queue?
Hi all: I was just wondering if this is normal as it's the first time that i've seen this. While browsing External Call History data, I noticed a call which has 3 Segments. However it appears that the segments are in reverse order for some reason. Segment 1 has a later Segstart time than...
Hi all, I'm fairly new to DTS however I believe that this is the tool needed for my situation and need some assistance.
We have a program which is FTPing csv files to a particular folder every 30 minutes or when the file reaches 20MB, whichever comes first. The files are labeled as such...
Hi all - I have an Excel Workbook with several sheets. Theses sheets draw there information from a hidden sheet which is automatically updated daily. This Workbook is then sent to various people daily and I'm trying to automate the process. However, I must open the Workbook daily to allow the...
Currently we have administered Aux work codes 1-9 for different functions. Is there a way that I can prevent all users from using a particular Aux code? Aux 7 for example.
I am trying to develope a Clock In/Clock Out application and need some direction. Here is what I am trying to do: I need a page which will allow the user to select from a dropbox the PIECE they will be working. Once they select a PIECE they click LOGIN button which then stores there REMOTE_USER...
Good Morning all: I have a survey built using FrontPage forms. The survey uses frame, a header and body. Everything is working just fine, however I would like my confirmation.asp page to open in the "_parent" frame when the user clicks the submit button. Is this possible?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.