Projects
Recent Project References
Radio Holland Group is specialised in the supply, installation and service of maritime electronics for applications at sea as well as on the inland waterways. Please find below recent project references, executed by Radio Holland around the world! Each market segment requires specific equipment and advice. This means that every solution we offer is tailormade.
CQWP_Query:
SELECT
TOP 50
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( '16596' ,0 ) )
-- Parent = 16596
Order by Isnull(showfrom, addDate) DESC
