CompanyName Addresstype Name  Addressline1       City     Country
ABC         Billing     John  252,Green street   Chicago  USA
ABC         Shipping    Jacob 152,Blue street    Chicago  USA
ABC         Contact     Jerry 102,yellow street  Chicago  USA
XXX         Billing     Rose  252,Green street   Newyork  USA
XXX         Contact     Ajay  102,yellow street

WITH CTE AS
(SELECT ROW_NUMBER() OVER(PARTITION BY COLUMN1 ORDER BY COLUMN1 ASC)AS ROW ,COLUMN1  FROM TABLE1)
UPDATE CTE SET COLUMN1=A.COLUMN1 FROM TABLE2 A WHERE CTE.ROW=A.COLUMN1;

SELECT A.DATE,A.NAME,A.COUNT1,B.DATE FROM TEMPTABLE A,TEMPTABLE B WHERE A.NAME=B.NAME AND A.DATE!=B.DATE AND 
A.DATE<=B.DATE
UNION ------------this union is to join same STARTDATE and ENDDATE
SELECT DATE,NAME,COUNT1,DATE FROM TEMPTABLE WHERE NAME IN(
SELECT NAME FROM
(SELECT COUNT(NAME) AS COUNT1,NAME FROM(
SELECT DISTINCT A.DATE AS STARTDATE,A.NAME,A.COUNT1,B.DATE AS ENDDATE

UPDATE SERVER1TABLE SET SERVER1TABLE.COLUMN1=B.COLUMN1,SERVER1TABLE.COLUMN2=B.COLUMN2
FROM OPENDATASOURCE('SQLNCLI','DATA SOURCE=SECONDSERVERNAME;UID=XXXX;PWD=XXXXX').DATABASENAME.DBO.SERVER2TABLE AS B
WHERE B.COLUMN1='XXXX' AND HRMS10EMPLOYEE.COLUMN1='XXXX'