I would try and rewrite it as a single query using case
statements. But the syntax that might work is
insert into @SomeTable (col1, col2, col3)
select (select count(*) from @OtherTable),
(select count(*) from @OtherTable),
(select count(*) from @OtherTable)
> [TWO_RACES] [int] NULL)
And that would be uumm... everybody. LMAO