News
CQWP_Query: SELECT TOP 75 Nr, Case when (CTSpecificVar30Im2 = 'EN' and len(CTSpecificVar200Im2)>1) then CTSpecificVar200Im2 when (CTSpecificVar30Im3 = 'EN' and len(CTSpecificVar200Im1)>1) then CTSpecificVar200Im1 when (CTSpecificVar30Im4 = 'EN' and len(CTSpecificVar200Im5)>1) then CTSpecificVar200Im5 else title End as title , target = CASE WHEN target IS NOT NULL THEN 'target="' + target + '"' ELSE '' END , ISNULL(ShowFrom,Adddate) as ShowFrom, Case when (CTSpecificVar30Im2 = 'EN' and len(CTSpecificVar200Im2)>1) then CTSpecificTextIm1 when (CTSpecificVar30Im3 = 'EN' and len(CTSpecificVar200Im1)>1) then CTSpecificTextIm9 when (CTSpecificVar30Im4 = 'EN' and len(CTSpecificVar200Im5)>1) then CTSpecificTextIm10 else description End as description , contenttype , CASE WHEN contenttype = 21 THEN ISNULL(ShowFrom,Adddate) ELSE null END AS newsDate , RTRIM(SUBSTRING( Case when (CTSpecificVar30Im2 = 'EN' and len(CTSpecificVar200Im2)>1) then CTSpecificTextIm1 when (CTSpecificVar30Im3 = 'EN' and len(CTSpecificVar200Im1)>1) then CTSpecificTextIm9 when (CTSpecificVar30Im4 = 'EN' and len(CTSpecificVar200Im5)>1) then CTSpecificTextIm10 else description End , 1, (CHARINDEX(' ', Case when (CTSpecificVar30Im2 = 'EN' and len(CTSpecificVar200Im2)>1) then cast(CTSpecificTextIm1 as varchar(200)) when (CTSpecificVar30Im3 = 'EN' and len(CTSpecificVar200Im1)>1) then cast(CTSpecificTextIm9 as varchar(200)) when (CTSpecificVar30Im4 = 'EN' and len(CTSpecificVar200Im5)>1) then cast(CTSpecificTextIm10 as varchar(200)) else description End + SPACE(60), 60)))) as ShortDescription, ShortDescriptionSuffix = CASE WHEN (LEN( Case when (CTSpecificVar30Im2 = 'EN' and len(CTSpecificVar200Im2)>1) then cast(CTSpecificTextIm1 as varchar(200)) when (CTSpecificVar30Im3 = 'EN' and len(CTSpecificVar200Im1)>1) then cast(CTSpecificTextIm9 as varchar(200)) when (CTSpecificVar30Im4 = 'EN' and len(CTSpecificVar200Im5)>1) then cast(CTSpecificTextIm10 as varchar(200)) else description End ) >= 60 AND 1 = 1) THEN '...' ELSE '' END FROM vwActive_DEF WHERE Nr IN (Select nr from dbo.fn_RecurseChildren( '9419' ,0 ) ) AND hiddenchild <> 1 -- Parent = 9419 AND DATEPART(yyyy,ISNULL(ShowFrom,Adddate)) = 2009 Order by Isnull(showfrom, addDate) DESC