Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rwaldron

  1. rwaldron

    export IMEI to excel

    Hi all, I am trying to export from sql table to excel in SSIS there is an IMEI column in SQL containing data like 123456789123456. When I export to excel the data is displayed as 1.23E+14. If I format in excel the cell to number and 0 decimals I get the 123456789123456 back. My question is what...
  2. rwaldron

    Sql query result to xml

    Hi all, I am trying to produce an XML to a web service from the result of an sql query..I am very close with below but when I run the asp.net page I get a blank page. Can someone help me. Do I need to use a dataset? Query does return data in sql. I want the final result to produce...
  3. rwaldron

    Historical Report setting

    Hiya , and thx for the reply. Just to confirm that you are using Symposium EXPRESS ? The only Option I have under system administration is "Backup". There may be a higher login required. So you are using EXPRESS ?
  4. rwaldron

    Historical Report setting

    Hiya and thx for the reply.. Yes I had a fealing that this was the case.. You say you do not have the documentation to check. Can you tell me which documentation can confirm this.. I may have some angry managers that I need to prove this too.. I also noticed that the Sym Express documnetation...
  5. rwaldron

    Historical Report setting

    Hi all, I am using Symposium Express Call Centre When I run the report Agent by Skillset Performace for last month I get no data returned. If I run this for last week I do get data returned. apparently "The number of days storage for different report types is defined under ....Historic...
  6. rwaldron

    ecallbycallstats table empty ??

    Thx for the reply but I finally got an answer to this. I have Symposium Express installed... In the User guide for SE there is a Note: Call By Call reports are NOT availiable with Symposium Express Call Center.. So unless I have the Full Symposium I can not do this :( Ray..
  7. rwaldron

    ecallbycallstats table empty ??

    Hi all, I an trying to get CLID of abandoned calls.. Apparently the tables in symposium that will give me the info are ecallbycallstat. However when I link to these tables through Crstal reports or SQL server the tables are EMPTY? Do I need to get this switch on somewhere ? Thx, Ray..
  8. rwaldron

    Conversion failed because the data value overflowed

    Hi all, I use sql server 2005 with a linked server to Pervasive. Using ODBC Pervasive version 10. My Problem is that there is a date field in Pervasive that can contain the value 00/00/0000. When I run and open query sql runs ok until it hots one of these dates.The I get the error "Conversion...
  9. rwaldron

    Conversion failed because the data value overflowed

    Hi all, I use sql server 2005 with a linked server to Btrieve. My Problem is that there is a date field in BTrieve that can contain the value 00/00/0000. When I run and open query sql runs ok until it hots one of these dates.The I get the error "Conversion failed because the data value...
  10. rwaldron

    Variable in DB2

    Hi all, Just to let you know. I got it working. In SQL its WHERE MMITNO =@MMITNO IN db2 its WHERE MMITNO = ? Thx, Ray..
  11. rwaldron

    Variable in DB2

    Hi all, Sorry if this is the wrong place to ask but I have tried a few places with no joy. In SQL when querying using a variable I can use @ symbol. ie: SELECT COUNT(*) FROM dbo.Persons WHERE SocialSecurityNumber = @SocialSecurityNumber Then in say visual web developer this would prompt me to...
  12. rwaldron

    Word 2000 Mail Merge Showing ????

    Hi all, I am trying to do a mailmerge in office 2000 from an excel spread sheet that contains the list of addresses. Some addresses in the excel sheet are in say the russian language. eg: "?????????? ???????, ?.??????" Excel shows the address no probs but when I do a mailmerge in word the adress...
  13. rwaldron

    Validate a CSV File ?

    Hi all, I need to validate some CSV files.They exist in a local folder and can have any name. eg: eir102.csv, eir103.csv I want to check for any csv files in a folder and validate..IF Validation ok then save to good folder IF Fail then save to bad folder. Anyone know a good example of reading...
  14. rwaldron

    Select data = to current date

    Hiya , the Date returned is 2007-11-15 00:00:00.000 how can I strip this down to just 2007-11-15 ? Thx, Ray..
  15. rwaldron

    Select data = to current date

    Hi all, I am trying to do something that sounds easy but in fact is turning out to be very difficult. I am trying to return data in DB2 where a field MTTRDT is equal to the current date..I know in DB2 I can use WHERE DB2 = CURRENT DATE........However my problem is that my MTTRDT field is not in...
See more

Part and Inventory Search

Back
Top