quote:

---

Originally posted by ramu143

previously i am using this quirey in SP

'
insert into '+@tb2+'
select yyyy,mm,dd,HH,sitecode,TrunkOut,SwitchCode,prefixCode,0 isCallback,
cast(callcost as decimal (10,5)) cost,count(*) attempt,
sum(case when connectflg=1 then 1 else 0 end) connected,sum(talktime) Talktime
from '+@tb1+'
where talktime >0 and where trunk is null
group by yyyy,mm,dd,HH,sitecode,TrunkOut,SwitchCode,prefixCode,cast(callcost as decimal (10,5))
order by yyyy,mm,dd,HH,sitecode,TrunkOut,SwitchCode,prefixCode,cast(callcost as decimal (10,5))
'

NOW I AM using BELOW one.


'
insert into '+@tb2+'
select yyyy,mm,dd,HH,sitecode,TrunkOut,SwitchCode,prefixCode,0 isCallback,
cast(callcost as decimal (10,5)) cost,count(*) attempt,
sum(case when connectflg=1 then 1 else 0 end) connected,sum(talktime) Talktime
from '+@tb1+'
where talktime >0 and where trunk is null or trunkin =’bridge’
group by yyyy,mm,dd,HH,sitecode,TrunkOut,SwitchCode,prefixCode,cast(callcost as decimal (10,5))
order by yyyy,mm,dd,HH,sitecode,TrunkOut,SwitchCode,prefixCode,cast(callcost as decimal (10,5))
'

now i am geeting errore in where talktime >0 and where trunk is null or trunkin =’bridge’ heare please solve this how can we use this one in Sp
ERRORE IS Incorrect syntax near the keyword 'where'.

---

' 
insert into '+@tb2+' 
select yyyy,mm,dd,HH,sitecode,TrunkOut,SwitchCode,prefixCode,0 isCallback, 
cast(callcost as decimal (10,5)) cost,count(*) attempt, 
sum(case when connectflg=1 then 1 else 0 end) connected,sum(talktime) Talktime 
from '+@tb1+' 
where talktime >0 and  trunk is null or trunkin =''bridge'' 
group by yyyy,mm,dd,HH,sitecode,TrunkOut,SwitchCode,prefixCode,cast(callcost as decimal (10,5)) 
order by yyyy,mm,dd,HH,sitecode,TrunkOut,SwitchCode,prefixCode,cast(callcost as decimal (10,5)) 
'

alter procedure ostat_CDS_rpt47_2006 
@pYear int, 
@pMonth int, 
@pDay1 int, 
@pDay2 int

as 
begin 

declare @sql varchar(4000) 
declare @tb1 varchar(128) 
declare @tb2 varchar(128) 
--select top 10 * from margin..ncds_missing_jun08 
--select * into ob_mar08_bckup from ob_mar08 
set @tb1= 'RPTMAIN.month10.dbo.lycacds1023' 
set @tb2='Report.dbo.ob_OCT08' 

set @sql= 
' 
insert into '+@tb2+' 
select yyyy,mm,dd,HH,sitecode,TrunkOut,SwitchCode,prefixCode,0 as isCallback, 
cast(callcost as decimal (10,5)) as cost,count(*) as attempt, 
sum(case when connectflg=1 then 1 else 0 end) as connected,sum(talktime) as Talktime 
from '+@tb1+' 
where talktime >0 and trunk is null or trunkin = ''bridge'' 
group by yyyy,mm,dd,HH,sitecode,TrunkOut,SwitchCode,prefixCode,cast(callcost as decimal (10,5)) 
order by yyyy,mm,dd,HH,sitecode,TrunkOut,SwitchCode,prefixCode,cast(callcost as decimal (10,5)) 
' 
--print (@sql) 
exec (@sql) 

end