Viewing 3 posts - 1 through 3 (of 3 total)
SELECT dbo.TC72_Employees.EmpID, dbo.TC72_Employees.EmpName, SUBSTRING(CAST(CONVERT(Date, dbo.TC72_PayrollWeek.WeekStart, 102) AS Varchar(12)), 6, 2)
...
December 27, 2011 at 12:55 pm
Add one Dummy Flag Filed to ContactGroupMember
Update This Flag as 1
by Following Command
UPDATE ContactGroupMember
SET Flag = 1
FROM ContactGroupMember
INNER JOIN #FinalResults AS FR ON ContactGroupMember.ContactGroupId = FR.ContactGroupID and
...
December 22, 2011 at 7:07 am
Add one Dummy Flag Filed to ContactGroupMember
Update This Flag as 1
by Following Command
UPDATE ContactGroupMember
SET
FROM ContactGroupMember AS CGM
INNER JOIN #FinalResults AS FR ON CGM.ContactGroupId = FR.ContactGroupID
WHERE cgm.ContactId <> fr.OwnerID
December 22, 2011 at 7:03 am
Viewing 3 posts - 1 through 3 (of 3 total)