Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Become a Premium Member and unlock a new, free course in leading technologies each month.
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
create table #a ( ident int identity, a int,b int)
insert into #a (a,b)
select n, case when n%10000=0 then 0 else case when n%300=0 then 2 else n/2 end end
from vw_nums
where n < 500000
select ident,a,b,a/b from #a
where b<>0 and b is not null
select ident,a,b,a/b from #a
where ident in (select ident from #a where b <> 0 and b is not null)
go
drop table #a
create table #a ( ident int identity, a int,b int)
insert into #a (a,b)
select n, case when n%10000=0 then 0 else case when n%300=0 then 2 else n/2 end end
from vw_nums
where n < 500000
select ident,a,b,a/b from #a
where b<>0 and b is not null
select ident,a,b,a/b from #a
where ident in (select ident from #a where b <> 0 and b is not null)
select ident,a/b from #a
where b<>0 and b is not null
select ident,a/b from #a
where ident in (select ident from #a where b <> 0 and b is not null)
go
drop table #a
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.