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( '15781' ,0 ) )
AND hiddenchild <> 1
-- Parent = 15781
Order by Isnull(showfrom, addDate) DESC
De Tormax iMotion 2401 schuifdeuraandrijving opent deurvleugels...
Imtech Security Solutions is uw adviseur voor en leverancier...
Imtech verzorgt onderhoud voor grote woningcorporatie in Friesland...
FAAC professional behaalt type goedkeur met FAAC motoren
Nieuwe entreeoplossing voor winkels
Imtech speelt eerste viool bij het Muziekcentrum van de Omroep...
12|01|2011 'Ons bedrijf loopt elke dag een dag voor'
21|10|2010 CareManagement: verhoogt zelfredzaamheid, verlaagt...
13|09|2010 AkzoNobel beschikt straks over één management platform...
02|08|2010 iMotion 2301 wint Red Dot Design Award
22|06|2010 Imtech intercom toe aan dienstverlening
09|06|2010 Imtech haalt prestatieladder niveau 3
07|06|2010 Imtech Security Solutions toont nieuwe website securitysolutions.nl...
04|02|2010 LED buitenverlichting: beter beeld, lager energieverbruik...
11|11|2009 Donderdag 19 november, 21ste NIDV symposium
21|09|2009 Imtech bundelt Security-krachten in Imtech Security...
14|06|2008 De Imtech Access & Security Roadshow langs de...
22/08/2008 Power Drive 1401
15|03|08 - Ultieme kracht gecombineerd met maximale veiligheid...
In april 2008 vond de Beurs Passenger Terminal Amsterdam Rai...
30/09/2008 Advertorial magazine 'Profiel'
08|01|2009 Service Scooter