alter PROCEDURE [dbo].[rendelesprodname3]
AS
begiN
DECLARE @i int
set @i = 0
declare @max int
declare @maxmaxmaxmaxmax int
declare @asd int
declare @indexindexindex int
set @maxmaxmaxmaxmax = 0
set @max = (select max(campaignid) from [dbo].Campaign)
while (@i < @max)
BEGIN


set @asd = (select SUM(p.alma) from (
	SELECT [dbo].[Products].[UnitPrice]*[dbo].[Order Details].[Quantity] as alma
		FROM [dbo].[Order Details] JOIN dbo.Products ON [dbo].[Order Details].[ProductID] = dbo.Products.ProductID
			WHERE [dbo].[Order Details].[OrderID] IN(
				SELECT dbo.Orders.OrderID FROM dbo.Orders, dbo.Campaign
					WHERE dbo.Orders.EmployeeID IN(
						SELECT dbo.EmployeeTerritories.EmployeeID FROM dbo.EmployeeTerritories
							WHERE dbo.EmployeeTerritories.TerritoryID IN(
								SELECT dbo.Territories.TerritoryID FROM dbo.Territories
									WHERE dbo.Territories.RegionID IN(
										SELECT dbo.University.RegionID FROM dbo.Campaign INNER JOIN dbo.University ON dbo.Campaign.UniversityId = dbo.University.UniversityId
											WHERE (dbo.Campaign.CampaignID = @i )
									)
						)
					)
) ) as p )

Print @asd

if ( @maxmaxmaxmaxmax <  @asd ) BEGIN


set @maxmaxmaxmaxmax = @asd

SET @indexindexindex = @i

END

set @i = @i + 1

END

Print 'utso'
Print @maxmaxmaxmaxmax
Print 'indexe'
Print @indexindexindex

end


exec [dbo].[rendelesprodname3]