Hugo Kornelis (11/9/2010)
john.arnott (11/8/2010)
Hmmm. When I run this code to build the table, "Select 1 from #test" returns two rows, each with a "1". It's an implied join, isn't it? . . . .Nope, no join at all. . . . .
Thanks, Hugo. That's certainly clear and I did misuse the term "join". But my main intent in posting was to ask Sanjay (or anyone who could explain) why he got a 1 for his result set where I (and presumably you) would get multiple rows returned, each with the constant 1.
He posted that after the two inserts,
...when you execute
select 1 from #test
you get result as 1
Perhaps he meant to say "you get results as multiple rows of 1".