If Exists (Select * From sysobjects Where name = N'lw_getActivityList' And user_name(uid) = N'dbo')
Drop Procedure dbo.lw_getActivityList
Go
CREATE Procedure lw_getActivityList (
@groupId int
)
AS
set nocount on
select activityId,description from activity
where groupId=@groupId
order by dueDate
return
Go