sql server 合并多个选择结果

refs:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6fd531d0-1276-4a6a-a63d-aafc8ced515f/combine-multiple-result-sets-into-one-xml-result-set?forum=sqlxml

sql server可以通过union来把同类型(相同列)的结果合并在一起，也可以通过join把相关表联合后在做select，但对于不相干的表，且结果类型也不一致，则只能通过其他方式来解决了，refs中的链接是很有效的参考。

select 
 (select  count(1) from by_etor_tickets where status<5 ) as ticket_count ,
 (select  count(1)  from by_v_etor_detail where status=1 )as etor_online_count,
 (select  count(1)   from by_v_etor_detail where status!=1 and status!=4 ) as etor_offline_count , 
 (select CONVERT(varchar(100) , getdate(), 20 ))  as datetime