A word of caution, this query will not perform well over large datasets. Your data needs to be processed in a partitioned fashion (by OfficerID, FirstName and LastName) and then...

In SSMS on Server1 try connecting to these and let us know:

Server2,1433

Server2,49156

Server2,49162

niladri.primalink (3/4/2016)

---

if there is address is Available in last row (in this case row 6) we don't need to update. But if the row no 6 has not the address...

Igor Micev (3/4/2016)

---

Hi Grant,

Can you put here some advantages...

Great, thanks. From my earlier post on how to handle address data, using your sample data what do you want retained in the HomeAddress of the surviving row? Would you...

assefamisganaw (3/4/2016)

---

When I use the following Value,

LINKED SERVER : Instance2

Provider : Microsoft OLE DB Provider for SQL Server

Product Name: SQLSERVER

Data Source : Server2\Instance2

Provider String: empty / No Value is given/

Catalog:Database2...

Nice work finding the solution on your own and thanks for posting it for others.

assefamisganaw (3/4/2016)

---

I told the Network Admin to OPEN port Number 1433 and 1434 in the firewall

Using the tool, it returns the following status from Server 2

TCP...

niladri.primalink (3/4/2016)

---

Hi,

Thanks fro you reply. Next time I will be careful. Here are all the columns the table I have

contactid,FirstName,lastname,officerid,

email,Homephone,workphone,Fax,HomeAddress1,HomeAddress2,Homecity,HomeState,

HomeZip,Title,workaddress1,workaddress2,workcity,workcity,workstate,workzip

Hope it will help you. Please guide me.

Also let me know...

sql2k8 (3/2/2016)

---

I am getting the below mentioned error message when running the SSIS package through the SQL Server agent.

Error: Opening a rowset for "Test_Table$" failed. Check that the object exists...

Jeff Moden (3/3/2016)

---

tony28 (3/3/2016)

---

I have to strongly disagree with that. Some poor bugger in a...

risingflight143 (3/4/2016)

---

Hi everyone i want to reindex plz guide me with the command

Object Schema Object Name ObjectId ...

niladri.primalink (3/4/2016)

---

Hi All,

Hope you are doing great. Here I have a problem and I am sure you will help me out.

I have a table with full of duplicates. I have...

JesseBizInt (3/2/2016)

---

The tool was a custom tool that our consultant wrote. It basically is a Windows form application that prompts the user to fill in a bunch of values,...

assefamisganaw (3/4/2016)

---

When I tried to connect I am getting the following error.

TITLE: Microsoft SQL Server Management Studio

------------------------------

The test connection to the linked server failed.

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing a...