Using a Select as a Var??

Hi All
Need top repeat a select 3 times but with differents where condition. I tried to repeat the selects and after use a couple of union to join then, but it takes toooo long.

I also remember there was a way such as:

using var (select stamment)
select *
from var
where .....

but i can not remember the exact syntaxes.

Does anybody know?.

Thanks. Received on Thu Jul 05 2007 - 10:50:51 CDT