Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
ramu143
Yak Posting Veteran
64 Posts |
Posted - 2008-09-27 : 02:08:37
|
Posted - 09/27/2008 : 00:18:18 -------------------------------------------------------------------------------- i have created one procedure name mohani want to job shedule this one out put is 5 columns very rare we are getting out put are we are gettig 0 rows effected the procedure is like below please modify this one if need and tell me how to job schedule this one.CREATE procedure MOHANas begin insert into cdb (machineid,operatorout,devbname,minutes,noofcalls,ACD)select machineid,operatorout,devbname,minutes,noofcalls,(minutes*1.0/noofcalls) as ACDfrom(select machineid,operatorout,devbname,sum(talktime)/60 as minutes,count(*) as noofcalls from wholesale.margin.dbo.cdbwhere operatorout not like '%_in' and connectflag='1' and devbname like 'dac%' group by machineid,operatorout,devbname )torder by machineid,operatorout,devbnameselect * from CDB where ACD<1 and noofcalls>30 order by ACD ,noofcalls--- THIS IS THE OUT PUT I NEED TO GET IN JOB SHEDULE>end GO |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-27 : 02:21:35
|
why are reposting questions again?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=111517 |
|
|
|
|
|
|
|