select POWER(convert(bigint,2),31) as val into #temp
I see what you did there 😉
Recycling is good for the environment 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP