Текст хранимой процедуры:
\nCREATE PROCEDURE SameValuesInFields
@TABLE_SCHEMA nvarchar(128 ), --table owner
@TABLE_NAME nvarchar(128 ) --table name
AS

/*
Условимся, что PK определен на одном поле типа int, стоящем на первом месте
*/
create table #tmp_result
(
column_ordinal_position int not null,
column_value sql_variant not null,
PKFromTable int not null
)
DECLARE @PK_NAME nvarchar(128 )
Select
@PK_NAME=COLUMN_NAME
from
INFORMATION_SCHEMA.Columns
where
ORDINAL_POSITION=1 AND
TABLE_NAME=@TABLE_NAME AND
TABLE_SCHEMA=@TABLE_SCHEMA

DECLARE cur CURSOR FOR
Select
COLUMN_NAME,
ORDINAL_POSITION
from
INFORMATION_SCHEMA.Columns
where
TABLE_NAME=@TABLE_NAME
AND TABLE_SCHEMA=@TABLE_SCHEMA
AND ORDINAL_POSITION>1
Order By
Ordinal_Position

DECLARE @SQLText nvarchar(4000), @ORDINAL_POSITION int, @COLUMN_NAME nvarchar(128 )

open cur

fetch next from cur into @COLUMN_NAME, @ORDINAL_POSITION

while @@fetch_status=0
BEGIN
Set @SQLText=
'Select '+CAST(@ORDINAL_POSITION As varchar(10))+' As column_ordinal_position, '+
't1.['+@COLUMN_NAME+'] As column_value, '+
't1.['+@PK_NAME+'] As PKFromTable '+
'From '+
@TABLE_SCHEMA+'.['+@TABLE_NAME+'] t1 '+
'inner join '+@TABLE_SCHEMA+'.['+@TABLE_NAME+'] t2 '+
'on t1.['+@COLUMN_NAME+']=t2.['+@COLUMN_NAME+'] AND '+
't1.['+@PK_NAME+']<>t2.['+@PK_NAME+'] '+
'Group By t1.['+@COLUMN_NAME+'], t1.['+@PK_NAME+'] '+
'HAVING Count(*)>1'
INSERT INTO #tmp_result execute (@SQLText)
fetch next from cur into @COLUMN_NAME, @ORDINAL_POSITION
END

close cur
deallocate cur

Select * from #tmp_result
GO


Пример использования:
\ncreate table tmp
(
pk int identity(1,1) not null primary key clustered,
name1 nvarchar(10) not null,
name2 int not null,
name3 money not null
)
go

insert into tmp (name1, name2, name3) values ('a', 0, 1)
insert into tmp (name1, name2, name3) values ('b', 1, 2)
insert into tmp (name1, name2, name3) values ('c', 0, 1)
insert into tmp (name1, name2, name3) values ('c', 0, 3)
insert into tmp (name1, name2, name3) values ('b', 1, 2)
insert into tmp (name1, name2, name3) values ('c', 1, 5)
insert into tmp (name1, name2, name3) values ('a', 0, 1)
insert into tmp (name1, name2, name3) values ('b', 1, 2)
insert into tmp (name1, name2, name3) values ('b', 1, 2)
insert into tmp (name1, name2, name3) values ('a', 0, 1)
insert into tmp (name1, name2, name3) values ('z', 111111, 111111)
go

execute SameValuesInFields 'dbo','tmp'

drop table tmp
go


Это то, что нужно было получить?