Hi,

ACTPR – ODBC/SQL error

Hi all,

I have a SQL table named “Employee”. The table consists of the fields: Emp_Id, Emp_date, Emp_msg. The Emp_Id column can have more than one same entry in the table. The fields are separated by ‘|’.

Example: data in the SQL table
231| 10102009| T1
231| 11102009| T2
231| 11102009| T3
I have tried to write a select statement that will put these each Emp_Id in one line.
Example: data of the resultant output.
e.g.
231| 10102009| T1| 11102009| T2| 11102009| T3
It was difficult to write a query for this. Could anyone help me write a query for this?

Thanks.

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.

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

Hi everyone,

One of my production SQL Job is failing with the message "Timeout expired (SQL State: HYT00 Natice Error: 0)" as shown in image attached.

Hi,

I would like to know how to setup the OLEDB Destination dynamic SQL Table name in SSIS. I have designed the Raw File Source Tasks which would pick up the source files dynamically. And I connected the Source Task to an OLEDB Destination Task. The OLEDB Destination tasks SQL Table name should be changed dynamically.

I have tried using variable name. But in the Connection Editor page, I can’t select the Table Name variable which was declared previously. Please let me know the solution for this issue.

Thanks in Advance.
Karthik.