Uite și un exemplu:

USE tempdb

DECLARE @Result TABLE (
ObjectName sysname,
ColumnName sysname,
TheRank int
)

INSERT INTO @Result
SELECT o.name, c.name, DENSE_RANK() OVER (ORDER BY o.name)
FROM sys.columns c
INNER JOIN sys.objects o ON c.object_id = o.object_id
WHERE o.type='S'

INSERT INTO @Result
SELECT o.name, c.name, DENSE_RANK() OVER (ORDER BY o.name)+ISNULL((SELECT MAX(TheRank) FROM @Result),0)
FROM sys.columns c
INNER JOIN sys.objects o ON c.object_id = o.object_id
WHERE o.type<>'S'

SELECT * FROM @Result

Răzvan