SET NOCOUNT ON

DECLARE @T_TABLE TABLE
(
		[Srl#] INT,
		idcode1  INT,
		Idcode2  INT,
		Addr1  VARCHAR(100),
		Addr2  VARCHAR(100), 
		Addr3  VARCHAR(100), 
		Addr4 VARCHAR(100)
)
INSERT INTO @T_TABLE
SELECT 1 AS ID, 5623, 235, '277 RANCHEROS DR, STE 920 740', 'NORDAHL ROAD #127', 'PO BOX 5067042 200 S', 92231 UNION ALL
SELECT 2, 252, 765, '277 RANCHEROS DR, STE 920 740', 'NORDAHL ROAD #127', 'PO BOX 5067042 200 S', 92231 UNION ALL
SELECT 3, 245, 5678, '277 RANCHEROS DR, STE 920 740', 'NORDAHL ROAD #128', 'PO BOX 5067042 200 S', 92231 UNION ALL
SELECT 4, 587, 7456, '277 RANCHEROS DR, STE 920 740', 'NORDAHL ROAD #128', 'PO BOX 5067042 200 S', 92231 UNION ALL
SELECT 5, 78, 7967, '277 RANCHEROS DR, STE 920 740', 'NORDAHL ROAD #128', 'PO BOX 5067042 200 S', 92238 UNION ALL
SELECT 6, 785, 5678, '277 RANCHEROS DR, STE 920 740', 'NORDAHL ROAD #129', 'PO BOX 5067042 200 S', 92231 UNION ALL
SELECT 7, 578, 3563, '277 RANCHEROS DR, STE 920 740', 'NORDAHL ROAD #129', 'PO BOX 5067042 200 S', 92231

SELECT [Srl#],
		idcode1,
		Idcode2,
		CASE WHEN RowNo <> 1 then '####' ELSE Addr1 END AS Addr1,
		CASE WHEN RowNo <> 1 then '####' ELSE Addr2 END AS Addr2,
		CASE WHEN RowNo <> 1 then '####' ELSE Addr3 END AS Addr3,
		CASE WHEN RowNo <> 1 then '####' ELSE Addr4 END AS Addr4
FROM (
		SELECT *, ROW_NUMBER() OVER (PARTITION BY Addr1, Addr2, Addr3, Addr4 order by [Srl#]) AS 'RowNo'
		FROM @T_TABLE		
		) A
ORDER BY [Srl#]

"There is only one difference between a dream and an aim.
A dream requires soundless sleep to see,
whereas an aim requires sleepless efforts to achieve..!!"