Faye Fouladi (12/24/2012)

---

How do I correct the following statement:

Declare @Component smallint = -1

Select srcComment.Comment As Comment, t.NameFull As CommentType, parenttypeId As Component,
(select Quarter From dimPeriod where periodId = srcComment.ParentId) As Quarter,
(select Year From dimPeriod where periodId = srcComment.ParentId) As periodYear
From srcComment
inner JOIN dimPeriod p
ON srcComment.ParentId = p.periodId
Left Outer Join refType t
ON t.TypeId = srcComment.ParentTypeId
where case @Component
when -1 then
parenttypeId IN (601, 605, 606)
else parenttypeId = @Component End