ALTER PROCEDURE "DBA"."nieobecnosc_lekarza" (@idLekarza INT,@funkcja VARCHAR(50), @nb DATE)
AS
BEGIN
DECLARE @zmiennik INT
DECLARE @datazabieg DATE
DECLARE @idz INT
DECLARE @zmienna INT
DECLARE kursor CURSOR FOR
SELECT Z.data_zabieg, Z.id_zabieg INTO @datazabieg,@idz
FROM ZABIEG Z JOIN zespol_zabiegowy zes ON ( Z.id_zabieg=zes.id_zabieg)
WHERE zes.id_pracownik=@idLekarza AND Z.data_zabieg=@nb
/* wybieramy zmiennika */
SET @zmiennik = (SELECT TOP 1 P.id_pracownik
FROM PRACOWNIK P
WHERE id_pracownik <> @idLekarza AND P.funkcja_szpital= @funkcja
ORDER BY P.id_pracownik)
OPEN kursor WITH HOLD
WHILE @@FETCH_STATUS= 0
BEGIN
FETCH NEXT kursor INTO @datazabieg,@idz
BEGIN TRANSACTION
UPDATE zespol_zabiegowy
SET id_pracownik=@zmiennik
WHERE id_pracownik=@idLekarza AND id_zabieg=@idz
COMMIT TRANSACTION
END
CLOSE kursor
END
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}