Query or SP Help Please

[MrktMind]

I need to return a total of 10 rows. If not enough rows are returned from the first select statement I need to fill in the remaining empty rows with rows from an additional select statement.

Some general ideas of possibilities to solve this would be greatly appreciated!

John

 

[markros]

Using temp table

declare @cnt int
select top 10 myFields into #temp from ...
select @cnt = @@ROWCOUNT

if @cnt < 10
select * from #temp
union
select top (10 -@cnt) ... from another table

else
   select * from #temp

PluralSight Learning Library

 

[PWise]

Simple

Select top 10 *
from(Select top 10 * ,a idx
     from tablea
     union
     Select top 10 * ,b idx
     from tableb
     )dt
order by idx

 

[MrktMind]

Thanks for the help!!