Conversion failed when converting the nvarchar value '2859.0' to data type int.

Hey, Alex. I would appreciate it if you could help me, I can't figure out how to fix this error: Conversion failed when converting the nvarchar value '2859.0' to data type int.

thank you

Select dea.continent, dea.location, dea.date, dea.population, vac.new_vaccinations , SUM(CONVERT(int,vac.new_vaccinations)) OVER (Partition by dea.Location Order by dea.location, dea.Date) as RollingPeopleVaccinated From Protfolioproject..coviddeaths dea Join Protfolioproject..covidvaccination vac On dea.location = vac.location and dea.date = vac.date where dea.continent is not null order by 2,3

4 Comments

  1. change the "int" into "bigint"

    hi i already changed "int" into "bigint" but still give an error message
    RDER BY list of RANGE window frame has total size of 1020 bytes. Largest size supported is 900 bytes.

    anyone up to help? please

  2. not able to partition by over location and date gives error byte size