News

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( '11082' ,0 ) ) AND hiddenchild <> 1 -- Parent = 11082 AND DATEPART(yyyy,ISNULL(ShowFrom,Adddate)) = 2008 Order by Isnull(showfrom, addDate) DESC

Radio Holland Testing ASP LRIT for Dutch, Dutch Antilles and Aruban flag ships (December 19 2008)

Rotterdam Decoration For Mr. François van Hoorn (October 31 2008)

On Thursday 23 October the Alderman of Economics, Harbour and...

Pieter Bloemendaal Managing Director of Royal Dirkzwager (October 15 2008)

As of 1st November Pieter Bloemendaal will become Managing Director...

Radio Holland signs contract with Pole Star for LRIT testing (October 15 2008)

On 8 October the Radio Holland Group (Rotterdam) signed a contract...

Imtech: 40 miljoen euro orders voor milieuvriendelijke voortstuwing (September 29 2008)

Imtech: 30 miljoen euro orders voor uitbreiding marinevloten (September 11 2008)

Agreement Royal Dirkzwager and Port of Rotterdam (September 2 2008)

Radio Holland Group selects Key Equipment Finance as leasing partner (July 31 2008)

Radio Holland Group announces that they selected Key Equipment...

Managementwisseling en groei bij Radio Holland (July 14 2008)

Radio Holland, Imtech Marine & Offshore and Free Technics together at Monaco Yacht Show (July 10 2008)

At the Monaco Yacht show (24-27 September), three companies...

Lancering van de Imtech Marine Group tijdens SMM in Hamburg (June 3 2008)

Tijdens ’s werelds grootste maritieme beurs, SMM Hamburg...

Imtech best supplier of Meyer Werft (April 21 2008)

Meyer Werft has awarded Imtech Deutschland the title of “Partner...

50 miljoen euro orders voor milieuvriendelijke hightech werkschepen in olie- en gasmarkt (April 15 2008)

Imtech breidt maritiem netwerk in Canada uit (April 11 2008)

Imtech versterkt maritieme portfolio met overname van Van Berge Henegouwen Installaties (April 1 2008)

Imtech breidt mondiaal maritiem netwerk uit in Zuid-Afrika, Panama en Noorwegen (March 6 2008)

Imtech Marine & Offshore involved in major refit former S-frigate into Giga yacht in United Arab Emirates (February 4 2008)

Recently Imtech Marine & Offshore (IM&O) celebrated...

Imtech: orders 96 million euro for technology on luxury yachts and cruise ships (January 30 2008)

Imtech (technical services provider in Europe) announces that...

Radio Holland commissions first Fleet Broadband Sailor-500 Fleet broadband terminal. (January 16 2008)

In December 2007 Radio Holland installed and commissioned the...

Radio Holland awarded Great Lakes VSAT order (January 16 2008)

Radio Holland, a globally renowned maritime electronics solutions...