, если вам нужен список дат между двумя датами:
create table #dates ([date] smalldatetime)
while @since < @to
begin
insert into #dates(dateadd(day,1,@since))
set @since = dateadd(day,1,@since)
end
select [date] from #dates
* скрипка здесь: http://sqlfiddle.com/#!6/9eecb/3469
Используйте https://docs.microsoft.com/en-us/visualstudio/msbuild/customize-your-build#directorybuildprops-example:
<Project>
<PropertyGroup>
<ResolveAssemblyWarnOrErrorOnTargetArchitectureMismatch>None</ResolveAssemblyWarnOrErrorOnTargetArchitectureMismatch>
</PropertyGroup>
</Project>