26.7 C
Chennai, India
Tuesday, January 25, 2022 02:15 PM
MS SQL Server

MS SQL Server

Hi,

We are implementing some new technology in our workplace, one of them is migrating our application to a new server. When I was done transferring all the data to a new server, I tested the application and I got an error that said, I cannot connect to the SQL server for the reason of login fails.

ACTPR – ODBC/SQL error [Microsoft][ODBC SQL Server Driver][SQL Server] Cannot open database requested in login ‘ACT7Demoa’. Login fails.

ACTPR – ODBC/SQL error

  • 1513 views
  • 1 answers
  • 0 votes

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.

  • 841 views
  • 1 answers
  • 0 votes

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:

  • 1060 views
  • 2 answers
  • 0 votes

Hi,

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

  • 871 views
  • 1 answers
  • 0 votes

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.

  • 837 views
  • 1 answers
  • 1 votes

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.

  • 3055 views
  • 1 answers
  • 1 votes

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

  • 876 views
  • 2 answers
  • 21 votes

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

  • 6769 views
  • 2 answers
  • 20 votes

 

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.

  • 1151 views
  • 1 answers
  • 20 votes

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.

  • 5345 views
  • 2 answers
  • 20 votes

Articles

Blogs

Tips