update PriceList   set PriceAll = 75 where PriceAll = 73 and PriceKindNo = 3

go

update PriceList   set PriceAll = 70 where PriceAll = 68 and PriceKindNo = 3

go

update PriceList  set PriceAll = 90 where PriceAll = 88 and PriceKindNo = 9

go

update PriceList set PriceAll = 85 where PriceAll = 83 and PriceKindNo = 9

go
if (not exists(select N from PriceSeasonPeriods where N=1 and SeassonNo=1))
then INSERT INTO PriceSeasonPeriods(N,StartDate,EndDate,SeassonNo) VALUES('1','01.10.2008','30.04.2009','1')
end if

GO
if (not exists(select N from PriceSeasonPeriods where N=2 and SeassonNo=2)) then
INSERT INTO PriceSeasonPeriods(N,StartDate,EndDate,SeassonNo) VALUES('2','01.05.2009','30.09.2009','2')
end if

GO
if (not exists(select N from PriceSeasonPeriods where N=3 and SeassonNo=1)) then
INSERT INTO PriceSeasonPeriods(N,StartDate,EndDate,SeassonNo) VALUES('3','01.10.2009','30.04.2010','1')
end if

GO
if (not exists(select N from PriceSeasonPeriods where N=4 and SeassonNo=2)) then
INSERT INTO PriceSeasonPeriods(N,StartDate,EndDate,SeassonNo) VALUES('4','01.05.2010','30.09.2010','2')
end if

GO
if (not exists(select N from PriceSeasonPeriods where N=5 and SeassonNo=1)) then
INSERT INTO PriceSeasonPeriods(N,StartDate,EndDate,SeassonNo) VALUES('5','01.10.2010','30.04.2011','1')
end if

GO
if (not exists(select N from PriceSeasonPeriods where N=6 and SeassonNo=2)) then
INSERT INTO PriceSeasonPeriods(N,StartDate,EndDate,SeassonNo) VALUES('6','01.05.2011','30.09.2011','2')
end if

GO
if (not exists(select N from PriceSeasonPeriods where N=7 and SeassonNo=1)) then
INSERT INTO PriceSeasonPeriods(N,StartDate,EndDate,SeassonNo) VALUES('7','01.10.2011','30.04.2012','1')
end if

GO
if (not exists(select N from PriceSeasonPeriods where N=8 and SeassonNo=2)) then
INSERT INTO PriceSeasonPeriods(N,StartDate,EndDate,SeassonNo) VALUES('8','01.05.2012','30.09.2012','2')
end if