I have a stored procedure that will run daily. This SP will need to call another SP on a different server. To do this, I believe that I should be using sp_addlinkedserver, correct? The SP on t...
I need to reach in and look at data in Worldship..
Hi experts,
I have a big text file (4 gigs; 7 million lines). I'm trying to import this to ACL, but found that it gave me an error "can only defineASCII file with carriage return/line feed ...
I am parsing a DHCP log with Log Parser 2.2. The results are exported to a .csv file and I need to reverse the IP address column.
The IP in the DHCP log is written like : 14.13.12.11
The...
Here is the file verification report:
Checking Integrity Slip
---ERROR---
The Paradox table appears corrupted.
Index version does not match table version
Index version does not match ta...
Hi
I am currently drawing and ER diagram and am not sure about how to draw the diagram for the following: A bike must have at least 2 wheels but it may have more. The way that I would dra...
We are trying to configure Informatica LDAP. We can get connected to the LDAP server but are having difficult retrieving data. We are not certain what the syntax is for LDAP configuration sc...
Hello...
Is there any document or matrix that details which DBA Tools on the market are considered to be the best? There seems to be so many DBA Tools out there that it is hard to know which ...
Hi experts,
Please give me some trusted information about comparison between oracle 11g installed on Windows and oracle installed on Unix (linux, Sun os). Which is the best? I hesitate to cho...
I am looking for a software package (unix or windows based) that can do complex plot point graphs.
What makes them complex is that I have several series. Each series represents a vechicles ...
I'm trying to update one table with values from another table, but am having trouble with the syntax being changed by VS 2005 which adds a Cross Join to my query.
Here is what I want to do:...
I have a PDF text file that contains math equations and tabular content. I am looking for the best (hopefully free) utility to convert the content to MSWord while salvaging as much special cha...
I am attempting to access what I was told were ISAM files. Files reside in a folder called DATA; however, there are NO extensions on any filename.
I am searching for a tool that will allow...
When saving a Publisher file for use as a webpage, I get an error message that says :The Disk is full. Can not save (filename). Try another disk" The disk is not full. I have over 23GB of ...
I have a column of numbers in a table (Acess 2003) that I need to sort in order by the number itself ingoring the positive or negative factor
example
52.00
(16.58)
(3.00)
15.00
the r...
Can someone give an simple example of V-Optimal Histogram and MaxDiff histogram?
Hello.
I have an interesting challenge for you.
A little background:
Our product uses a relational database with data stored in FoxPro, SQL, or Oracle tables. For the tables involved in th...
Hi, I remember there was a way to change to text or object on web pages. It was something like Ctl+L or something like that. It allows you to change stuff around, but obviously you cannot in...
I have used a streamreader to open and collect the contents of a HTML file, which this does correctly. However when I add this data to a String parameter it suddenly changes some blank spaces...
Here's what i'm trying to do.
I have a xml file, and this xml file contains nodes like:
<Field Name="Address State" Type="System.String">STATE</Field>
<Field Name="Address Postal...
I can not seem to get my calculation to work o this data set. What am I missing?
Bassically I need a total/sumation on Price for each CompanyID. Here is the SQL:
SELECT tblCompany.Compan...
Hi,
From the return results of a query (which will only ever be one row), I'd like to split one of the fields into multiple rows based on length. For example if the max width is 80 and the fi...
Herein the attached paper entitled Malicious Sniffing System Detection Platform by Zouheir Trabelsi, Hamza Rahmanifrom the proceedings of 2004 international symposium on applications and inte...
Is there API in MS Visual C++ to manipulate TIFF files?
We are using SQL Server 2005 and I have been asked to begin a data warehouse project for our company. Although I'm comfortable with SQL, I know very little about data warehousing and I'm looki...
