Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROC HousePrice
- @HouseID INT
- AS
- DECLARE @result INT = 0
- DECLARE @buff INT
- DECLARE @MIN INT = ((SELECT MIN(КодКвартиры) FROM Квартира Квартира JOIN Дом ON Квартира.КодДома = Дом.КодДома WHERE Дом.КодДома = @HouseID))
- DECLARE @MAX INT = ((SELECT MAX(КодКвартиры) FROM Квартира Квартира JOIN Дом ON Квартира.КодДома = Дом.КодДома WHERE Дом.КодДома = @HouseID))
- DECLARE @i INT = @MIN
- BEGIN
- WHILE @i <= @MAX
- BEGIN
- EXEC @buff = ApartmentPrice @i, 200000, 100000, 100000
- SET @result = @result + @buff
- SET @i = @i + 1
- END
- PRINT 'Стоимость дома равна ' + CAST(@result as NVARCHAR)
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement