Nieuws
CQWP_Query:
SELECT
TOP 75
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( '16371' ,0 ) )
AND hiddenchild <> 1
-- Parent = 16371
Order by Adddate DESC
De beoogde activiteiten van het FDL sluiten naadloos aan op...
Imtech ICT heeft de Cisco Advanced Data Center Architecture...
Vanaf nu is het mogelijk om op een Smartsite website documenten...
Deze certificering onderstreept nogmaals dat het bedrijf voldoet...
Imtech ICT heeft het onderzoek Top Employers ICT 2011 succesvol...
Creditmanagement organisatie GGN heeft een contract met Imtech...
Imtech ICT Technical Systems zal zich bij start certificeren...
De Politieacademie heeft een twee jarige overeenkomst gesloten...
Imtech ICT Business Solutions heeft de Business Partner of the...
Star-MDC besteed het beheer van de ICT-infrastructuurbeheerdiensten...
Imtech ICT Performance Solutions heeft tijdens de IBM On Demand...
In samenwerking met Imtech ICT heeft Amsterdam RAI een oplossing...
Vodafone gaat samen met Imtech ICT een Managed Telefonie oplossing...
Imtech ICT heeft op het Ministerie van Economische zaken samen...
Imtech ICT investeert in de opleiding van Agile Architecten....
