I have a table structure and query below......
in the activity table there is a field named isCompleted and if this =1 then the activity is completed...
i want to pull this same report but only for the ppl in the XREFEmployeesInvitations that have completed activityId 10
/****** Object: Table [dbo].[XREFEmployeesInvitations] Script Date: 09/28/2010 15:03:05 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[XREFEmployeesInvitations](
[EmployeeId] [int] NOT NULL,
[ActivityId] [int] NOT NULL,
[IsSpouse] [bit] NOT NULL,
[HasBeenViewed] [bit] NOT NULL,
[IsCompleted] [bit] NOT NULL,
View Complete Post