BDG Scenario 3

lw_getActivityList.sql

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