Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table #lo
- (
- mnbr bigint
- )
- insert into #login (mnbr)
- select distinct (_ID)
- FROM [KDB].[am_LOGS].[dbo].[_LOG]
- WHERE time >= '2012-7-26 9:00:00
- Select count(*) as countreject
- from #lo
- create table #pffblo
- (
- mber_br
- )
- insert into #pffblo (mber_br)
- select distinct (mber_br)
- from individ ip with (nolock)
- join memb mp with (nolock)
- on( ip.i_id=mp.i_id and mp.p_type=101)
- where ip.times >= '2012-9-26 11:00:00.000'
- select count(*) as countaccept
- create table #final
- (
- countreject bigint
- , Countacceptbigint
- .....
- )
- insert into #final (Countreject, Countaccept....more rows here...)
- select Countreject, Countaccept, ...more rows selected from temp tables.
- from #final
- union
- (select * from #lo)
- union
- (select * from #pffblo)
- select *
- from #final
- drop table #lo
- drop table #pffblo
- drop table #final
- CREATE TABLE #Table1
- (
- col1 BIGINT
- )
- CREATE TABLE #Table2
- (
- col1 BIGINT
- )
- --populate the temporary tables
- CREATE TABLE #Final
- (
- col1 BIGINT
- )
- INSERT INTO #Final (col1)
- SELECT *
- FROM #Table1
- UNION
- SELECT *
- FROM #Table2
- drop table #table1
- drop table #table2
- drop table #Final
- CREATE TABLE #Table1
- (
- col1 BIGINT
- )
- CREATE TABLE #Table2
- (
- col1 BIGINT
- )
- --populate the temporary tables
- CREATE TABLE #Final
- (
- col1 BIGINT,
- col2 BIGINT
- )
- INSERT INTO #Final (col1, col2)
- select (SELECT Count(*) FROM #Table1) as a, (SELECT Count(*) FROM #Table2) as b
- select * From #Final
- drop table #table1
- drop table #table2
- drop table #Final
- create table #final
- (
- countreject bigint
- , Countaccept bigint
- .....
- )
- insert into #final (Countreject, Countaccept....more rows here...)
- select
- from
- (
- select count(*) value, 'Countreject' col -- your UNION ALL's here
- from #lo
- union all
- select count(*) value, 'countaccept' col
- from #pffblo
- ) x
- pivot
- (
- max(value)
- for col in ([Countreject], [countaccept])
- ) p
- select count(*) value, 'Countreject' col
- from #lo
- union all
- select count(*) value, 'countaccept' col
- from #pffblo
- insert into #final (Countreject, Countaccept....more rows here...)
- select max(case when col = 'Countreject' then value end) Countreject,
- max(case when col = 'countaccept' then value end) countaccept
- from
- (
- select count(*) value, 'Countreject' col -- your UNION ALL's here
- from #lo
- union all
- select count(*) value, 'countaccept' col
- from #pffblo
- ) x
- insert into #final (Countreject, Countaccept....more rows here...)
- select isnull(lo.Countreject, 0) Countreject,
- isnull(pffblo.Countaccept, 0) Countaccept
- from
- (
- select count(*) Countreject,
- row_number() over(order by (SELECT 0)) rn
- from #lo
- ) lo
- left join
- (
- select count(*) Countaccept,
- row_number() over(order by (SELECT 0)) rn
- from #pffblo
- ) pffblo
- on lo.rn = pffblo.rn
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement