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