Nieuws

   

CQWP_Query: SELECT TOP 50 Nr, Case when (CTSpecificVar30Im2 = 'NL' and len(CTSpecificVar200Im2)>1) then CTSpecificVar200Im2 when (CTSpecificVar30Im3 = 'NL' and len(CTSpecificVar200Im1)>1) then CTSpecificVar200Im1 when (CTSpecificVar30Im4 = 'NL' 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 = 'NL' and len(CTSpecificVar200Im2)>1) then CTSpecificTextIm1 when (CTSpecificVar30Im3 = 'NL' and len(CTSpecificVar200Im1)>1) then CTSpecificTextIm9 when (CTSpecificVar30Im4 = 'NL' 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 = 'NL' and len(CTSpecificVar200Im2)>1) then CTSpecificTextIm1 when (CTSpecificVar30Im3 = 'NL' and len(CTSpecificVar200Im1)>1) then CTSpecificTextIm9 when (CTSpecificVar30Im4 = 'NL' and len(CTSpecificVar200Im5)>1) then CTSpecificTextIm10 else description End , 1, (CHARINDEX(' ', Case when (CTSpecificVar30Im2 = 'NL' and len(CTSpecificVar200Im2)>1) then cast(CTSpecificTextIm1 as varchar(200)) when (CTSpecificVar30Im3 = 'NL' and len(CTSpecificVar200Im1)>1) then cast(CTSpecificTextIm9 as varchar(200)) when (CTSpecificVar30Im4 = 'NL' 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 = 'NL' and len(CTSpecificVar200Im2)>1) then cast(CTSpecificTextIm1 as varchar(200)) when (CTSpecificVar30Im3 = 'NL' and len(CTSpecificVar200Im1)>1) then cast(CTSpecificTextIm9 as varchar(200)) when (CTSpecificVar30Im4 = 'NL' 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( '567' ,0 ) ) -- Parent = 567 AND DATEPART(yyyy,ISNULL(ShowFrom,Adddate)) = 2008 Order by Isnull(showfrom, addDate) DESC

Energiezuinige verlichting (24 december 2008)

De inspiratie van regelen en plannen (19 december 2008)

Traffic Centers

Imtech: 40 miljoen euro orders voor mobiliteitsbevordering in Europa (25 augustus 2008)

Taskforce vindt kennis OVL belangrijk voor energiebesparing. (21 juli 2008)

Nieuwe locatie Peek Traffic in Polen (1 juli 2008)

Doorbraak railinframarkt (2 juni 2008)

Reductie fileleed (2 juni 2008)

Realtime informatie systeem station Best (12 april 2008)

Glasvezel storingsvrij transportmedium (4 april 2008)

Armaturen van Innolumis (3 maart 2008)

Veilige tunnels in Betuweroute (11 februari 2008)

Voorwerk Olympische Spelen Londen

Imtech en Lemnis: openbare verlichting gebaseerd op LED-technologie (30 januari 2008)