[ Hrvoje Balažinec @ 16.01.2007. 12:38 ] @
Radim proceduru u kojoj kursori brinu o tome da datum isporuke nije manji od datuma narudzbe: Code: if exists (select name from sys.procedures where name = 'CheckOrders') drop procedure CheckOrders go create procedure CheckOrders @Drzava nvarchar (15) with encryption as declare @OrderID int declare crsOrders cursor keyset for select OrderID from Orders where Orders.ShipCountry = @Drzava open crsOrders fetch next from crsOrders into @OrderID while @@fetch_status = 0 begin update Orders set Orders.RequiredDate = Orders.OrderDate where Orders.RequiredDate < Orders.OrderDate and Orders.OrderID = @OrderID fetch next from crsOrders into @OrderID end close crsOrders deallocate crsOrders /* execute CheckOrders 'France' */ i to sve radi, ali bi sad jos zelio dodati izlazni parametar @KolikoFetcheva koji bi davao rezultat koliko je kursor procitao redova. Kako da to izvedem? |