Hi,

I have a SQL table “Currency_exchange_rates” that has fields Currency_code, Currency_date and Currency_rate. The table consists of values in random order. I want it the Date field to be ordered according to the currency code.

Example in the table is:

Hi,

I have created a 3 SQL tables. The table details are as follows,

Hi,

I have to fix a program error, which should find those entries in table1 which do not have matching records in table2 and then insert records in table2, so that for each record in table1 there should be at least one corresponding match in table2.

First I am trying to return IDs in table1, which do not have a corresponding match in the second table and then want to insert. Below is the query which is not working as per expectation:

INSERT into Services(Services.FkLobbyId, Services.FkServiceId, Services.ServiceTime)
values (LobbyId, '26','1')
(Select LobbyId FROM Lobby WHERE (NOT EXISTS (SELECT FkLobbyId FROM ServiceProvided WHERE (Lobby.LobbyId = FkLobbyId))))

Thank you.

Hello guys and girls,

I am using Red Hat 5 and trying to install oracle 11G on it. Whenever I try to install the enterprise manager phase, the following error appears.

Enterprise manager configuration failed due to the following
error –
Listener is not up. Start the Listener and run EM Configuration
Assistant again.
Refer to the log file at
/u01/app/oracle/cfgtoollogs/dbca/orcl/emConfig.log for more
details.
You can retry configuring this database with Enterprise
Manager later by manually running /u01/app/oracle/product/11.1.0/db_1/bin/emca script.

Hello experts,

There are six teams in our network. We all use the Windows XP operating system and the six of us have access to a database of UPS worldship. However on one of my computers when I try to connect to the UPS Worldship database, I get the following error:

“UPS WorldShip

The system cannot connect to the shared files. Either these files are missing or there is a problem with your network connection. (C:UPSWSTD)

UPS WorldShip will now exit. Please contact your system administrator for assistance.”

The image is as follows:

Hi all,

In SSIS, while I was trying to run a batch file from a remote machine using the Execute Process Task, it was giving error and the task was getting terminated from the process. I have set all the properties correctly in the Execute Process Task. But the local batch file was running perfectly without any issues. Please help me to resolve this issue.

Thanks.

Hey guys,

Help me here.

I have never used Microsoft products before and recently I got a new project and so I had to install SQL Server 2005 on my machine for the professional development of Windows XP. I downloaded the SQL Server 2005 Express Edition and SQL server management studio express from the Microsoft site. Before installing update my windows SP3, which then began the installation of the SQL server that actually went all the routine controls and began installing, but half of the installation that displays an error that says;

 “Microsoft SQL Server 2005 Setup

Hi folks,

I have a problem while trying to install SQL Server 2008. I was previously using SQL Server 2005.

So I decided to upgrade to 2008, but instead of upgrading directly using the 2008 wizard, I opted to uninstall SQL Server 2005 first, then install 2008. Halfway during the installation I get the following error;

SQL Server Setup failure

            SQL Server Setups has encountered the following error:

            The handle is invalid. (Exception from HRESULT: 0x80070006 (E_HANDLE)). 

Hey guys…

I am at the most divesting risk of my life. Please help me. Our MySQL database is running okay, but still we are getting the following error from our client end software.

There was an error connecting to the database:

Can’t connect to MySQL server on ‘127.0.0.1’ (10061)

Hi everyone,

I am working with a program and I used MS Access 2003 as a back-end for my database. I have a field “Item no” and its data type is Auto Number. I want to start the numbering with 1000, so that the next number in auto number will be 1001, 1002 and so on. But the default value is 1.

How can I change this value? Kindly assist me with this one. Thanks for your answers.