quote:

---

Originally posted by steven.liberman1

USE [Version500_test!!!]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ================================================================
-- Author: Steven Liberman
-- Create date: February 14, 2011
-- Description: WEB_SO_Analyze
-- exec WEB_SO_Analyze
-- ================================================================
alter procedure dbo.WEB_SO_Analyze(

@department_id int,
@without_rota float output,
@with_rota float output,
@pct_with_rota float output
)

AS

Begin

set @without_rota=20;
set @with_rota=2;
set @pct_with_rota=1;

-- select * from employee order by emp_id


set @without_rota =
(select count(emp_id)
from dbo.employee
where @department_id = emp_department_id and emp_dt_termination is not NuLL)


set @with_rota =
(select count(emp_id)
from dbo.employee
where @department_id = emp_department_id and emp_dt_termination is NuLL)


--final function which calculates percentage
set @pct_with_rota = (@with_rota/(@without_rota+@with_rota));

print @without_rota
print @with_rota
print @pct_with_rota
End
Go

OK this is my code now, but the stored procedure is not executing or working properly

---