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_RHD
WHERE
Nr IN (Select nr from dbo.fn_RecurseChildren( '17498' ,0 ) )
AND hiddenchild <> 1
-- Parent = 17498
Order by Isnull(showfrom, addDate) DESC
Furuno en Imtech Marine (voorheen Radio Holland Netherlands)...
Imtech Marine heeft via zijn bedrijf Radio Holland Netherlands...
Venteville BV levert systemen voor ballastwater treatment en...
Radio Holland Netherlands BV hecht grote waarde aan de activiteiten...
Radio Holland, onderdeel van Imtech Marine, en Radio Zeeland...
De bekende Sailor marifoon RT-2048, die sinds 1987 op de markt...
Recent heeft Radio Holland Group, onderdeel van Imtech, besloten...
Radio Holland en Spliethoff hebben een contract getekend voor...
Radio Holland levert de bekende Furuno rivierradar RHRS-2005...
Imtech ziet een herstel van de technologische maritieme markt...
Radio Holland Netherlands tekende tijdens Construction &...
Radio Holland en Radio Zeeland presenteren gezamenlijk de nieuwste...
Recent heeft de Stichting Historisch Materiaal Radio-Holland...
