Für mein Archiv hier eine Muster für eine stored procedure:
CREATE
PROCEDURE Example
AS
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
open
#Cur
Fetch next from #Cur Into @Kundennr
while
@@fetch_Status = 0
begin
-- do something
end
close
#Cur
deallocate #Cur
END