Search results for query: *

Hello, we have a program running on a windows 2000 server. This programs loads data from excel files into a database. The program needs an excel addin to work properly. This addin in enabled in Excel and the addin is located in the user profile (lets call it X) which is used to start the...

Hello, I have a graph which has a formula (IF) as input. However if the formula returns no value it is still represented as a 0 value in the chart. If the formula returns no result the item should also not be shown in the graph. Can anybody tell me how to fix this. Thatnks in advance, Atomic...

Hi, I have some SQL statements that were developped by someone else and I am having a very hard time in understanding what the syntax does. Could anybody enlighten me? UPDATE Table_X SET Field1 = (SELECT avg(FIELD1) FROM Table_B WHERE Table_A.FIELD2 =...

Hello, I have a result from a query which I want to load into an excel file. The problem is that in my result I have an 18-digit number. Excel reads this as a number (1.9098090920-E09 or something) but it should regard it as text. Is it possible to create the query in such a way that Excel...

Hello, is it possible with Microsoft Virtual Machine to simulate an older type PC, so with less CPU power and memory....? Regards, Atomic Wedgie

Hi, is there an easy way to replace characters like: _ - ~ ! @ # $ % ^ & * ( ) : ; " ' { } | [ ] | < > ? in one go without writing a replace for each character? Regards, Atomic Wedgie

Hi, it is now week 33, but when I ask for the week in SQL it gives week 34. How can I solve this? First day of the week is Sunday at the moment. Regards, Atomic Wedgie

We have a Lotus Notes database where set values in the database setting, this is a profile document. From time to time this profile is emptied so all settings are gone. Lately it is happening quite frequently, 1 - 2 times a week. Does anybody have a clue why this could be. Regards, Atomic Wedgie

Hello, is it possible to update the values in a PivotTable without updating the data. For instance I have a pivottable that shows values in EUR and I want to convert the values to USD using some kind of macro or so. Regards, Atomic Wedgie

Hello, is there maybe a script available to set all fields to autosort that are used in a Pivot Table? Regards, Atomic Wedgie

Hello, we have an application bluid in c# running on a server. This application is scheduled to run very minute. The problem is that the application crashes every now and then, the message we get is: .... the memory could not be "read" We have also tried running the application with all code...

Hello, is it possible to start replication in Lotus Notes while Notes is not running? Regards, Atomic Wedgie

Hi, I created a package but when i try to run it i get the following error: "The connection for a task was not specified or was not found." I have absolutely got no clue what this means. I tested the source (which is a query) in DTS and in query analyser and it works correctly. I have tested...

Hi, I don't know if this is the best place to post this question but does anybody know a good way to describle the fields in a table. In many cases the fieldname speaks for itself or sometimes different fields in a table roughly mean the same. regards, Atomic Wedgie

Hi, Is it possible to just copy encrypted passwords from one table to another table? If not, is it possible at all and how. Regards, Atomic Wedgie

Hello, I have to copy data from an old database to a new database. The problem is that the new database uses newly defined relationships that differ from the old database and replace the old relations. What is the best, or a good way to copy the data. Does DTS offer functionality to get these...

Hello, does anybody know a good open source query analyser/tool which has intellisense? Regards, Atomic Wedgie

Hi, i have different tables in my database with a field where a unique &quot;timestamp&quot; value is held. The value looks like this: 0x0000000008810298 Is this value generated by the database and is it possible to convert this to something readable or what does this value exactly mean...

Hello, when I create an inline view in a select statement, is that view then stored in the database somewhere? Atomic Wedgie

Help, could anybody tell me why the following message is being generated? Server: Msg 1205, Level 13, State 61, Line 9 Transaction (Process ID 57) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction...