please help me for this Sp - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

please help me for this Sp

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 mohan

i 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 MOHAN

as
begin

insert into cdb (machineid,operatorout,devbname,minutes,noofcalls,ACD)

select machineid,operatorout,devbname,minutes,noofcalls,(minutes*1.0/noofcalls) as ACD
from
(

select machineid,operatorout,devbname,sum(talktime)/60 as minutes,count(*) as noofcalls from wholesale.margin.dbo.cdb
where operatorout not like '%_in' and connectflag='1' and devbname like 'dac%' group by machineid,operatorout,devbname
)t
order by machineid,operatorout,devbname

select * 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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources