D
D
d1maYak0vlev2021-08-31 13:39:05
SQL
d1maYak0vlev, 2021-08-31 13:39:05

The ORDER BY list of the RANGE window frame has a total size of 1020 bytes. The maximum supported size is 900 bytes. How to complete a request?

For this request

select death.location, death.continent, death.date, death.population, vacs.new_vaccinations
, SUM(CONVERT(int,vacs.new_vaccinations)) OVER (Partition by death.Location Order by death.location, death.Date) as RollingPeopleVaccinated
--, (RollingPeopleVaccinated/population)*100 
from PortfolioCovid.dbo.Deaths death
Join PortfolioCovid.dbo.Vaccinations vacs
  on death.location = vacs.location
  and death.date = vacs.date
where death.continent is not null


Microsoft SQL server says

Список ORDER BY оконной рамки RANGE имеет общий размер 1020 байт. Максимально поддерживаемый размер равен 900 байт.


How to "expand" the size to the required size for the request to be fulfilled?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question