Für mein Archiv hier eine Muster für eine stored procedure:
CREATE
AS
PROCEDURE Example BEGIN
Declare @Kundennr varchar(30)
Declare @CumulY Decimal(15,2)
Declare @CumulYminus1 Decimal(15,2)
set nocount on
declare #Cur Cursor forward_Only for select * from tabelle #Cur
open #Cur
Fetch next from #Cur Into @Kundennr
while @@fetch_Status = 0
begin
-- do something
end
close #Cur
deallocate #Cur
END