SELECT Name, Anzahl FROM Tabelle
|
|
|
create table #t(name varchar(20), anzahl int)
insert into #t VALUES ('Meier',5)
insert into #t VALUES ('Müller',1)
insert into #t VALUES ('Schmidt',2)
WITH THierarchy (Name, Anz, HierarchyLevel) AS
(
SELECT t.name, t.anzahl, 1 HierarchyLevel
FROM #t t
UNION ALL
SELECT t.name, t.anzahl, th.HierarchyLevel + 1 AS HierarchyLevel
FROM #t t
INNER JOIN THierarchy th ON th.HierarchyLevel<th.anz AND t.name = th.Name
)
SELECT Name, HierarchyLevel
FROM THierarchy
ORDER BY Name
|
|
|
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Hilke, Dominik
-- Create date: 11.3.2011
-- Description: <Description,,>
-- =============================================
CREATE FUNCTION [dbo].[RowExplode]
(
-- Add the parameters for the function here
@Number int
)
RETURNS @exploded TABLE (Rownumber int)
AS
BEGIN
DECLARE @i int;
SET @i=0;
WHILE @i<@Number
BEGIN
SET @i=@i+1
INSERT INTO @exploded (Rownumber) VALUES (@i)
END
RETURN
END
GO
|
|
|
|
|
|
|
|
|
Ansonsten super :)