Search results for query: *

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

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

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

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

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

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

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

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

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

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

Hi all, Can someone please help. I am trying to upload a pdf 1MB to Sharepoint server 2001. The green progress bar stops half way and the the page cannot be displayed appears. What I have noticed is that this upload is ok if I use an old version of internet explorer?As soon as I click upload in...

Hi all, I can connect remotely using a dialup connection to our internal network using checkpoint secure remote. When logged in I can go to a windows 2003 server via start run \\server2003 and all the shares come up. However if I try the same with a windows NT server eg: \\servernt then I get...

Hi all, Win2003 is giving me terrible trouble with permissions accees to websites on the server. From reading up on this I need to Give permission on my sites to the group IIS_WPG which SHOULD contain the Network Service account.. However my IIS_WPG has NO members and when I try to add network...

Hiya all.. This is drving me nuts.. I have a login page login.aspx from ASP.net 2.0 to SQL 2000 when I try to login from another machine.. I get the error Login Failed for nt authority\network service From reading up on this I know that I need to give the network service account access to my...

Hi all, can someone please help.. I am trying to query a database DB2.. I want to get back the last 4months (120 Days) of Despatch data using the CURRENT DATE register in sysibm/sysdummy1 I am trying to compare DESPATCH_DATE with CURRENT DATE SELECT CURRENT DATE AS TODAY ,zxdsdt as...

Hi all, I have a linked sevrer from SQL to DB2. I have a column in DB2 ( Called Dispatched ) that is in the form 200060125 ie: Todays Date. However within DB2 the Datatype of this field is NOT a date. It is an 8 Digit Numeric. How to I convert this to a proper data data type ( Directly in DB2)...

Hi all, I have a linked sevrer from SQL to DB2. I have a column in DB2 ( Called Dispatched ) that is in the form 200060125 ie: Todays Date. However within DB2 the Datatype of this field is NOT a date. It is an 8 Digit Numeric. How to I convert this to a proper data data type ( Directly in DB2)...

Hi all, I have spent a couple of weeks getting the hang of upgrading SP2001 to SP 2003 and how SP2003 will Automatically upgarde an older version..However there is one part of the process ( Part 5 ) that doesn't kick in automatically and so I was hoping someone could help. Steps are: 1. Backup...

Hi guys I have a mapped drive in XP Pro that displays as h:\ There is no way for me to check the exact details of where this drive has mapped to after I set it up..Does anyone know how to get the details of a mapped drive. Eg: if you setup a mapped drive and rename it to "map" there is no easy...

Hi all, I have SQL 2000 120 Trial installed on win2000 and am trying to find out when it will expire. If I goto add remove programs there is a "Date last used" for SQL but I don't know if this means the date it was installed.. Can any one help... Because I know when it expires SQL just stops...