News

CQWP_Query: SELECT TOP 50 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( '16600' ,0 ) ) -- Parent = 16600 AND DATEPART(yyyy,ISNULL(ShowFrom,Adddate)) = 2009 Order by Isnull(showfrom, addDate) DESC

Radio Holland opens office in Port Elizabeth, South Africa (December 8 2009)

Radio Holland Group announces the official opening of a new...

Imtech Marine Group at Marintec: Partners in technology (November 11 2009)

At the upcoming Marintec exhibition from 1 to 4 December, Imtech...

Eric van den Adel appointed as Managing Director of Imtech Marine Group (October 30 2009)

The Board of Management of Imtech announces the appointment...

FT NavVision®: a powerful modular conning system (October 22 2009)

FT NavVision® is a powerful modular conning, monitoring &...

Imtech Marine Group shows integrated solutions at boatshows in Ft Lauderdale and Amsterdam (October 22 2009)

At the Fort Lauderdale International Boat Show three companies...

MSA: the very best service levels (October 20 2009)

Having the very best service levels possible is a key part of...

Radio Holland adds Ku-band footprint to its global VSAT network (September 29 2009)

In August 2009, Radio Holland signed an agreement for the VSAT...

Imtech Marine Group at Europort (September 7 2009)

At the upcoming Europort exhibition from 3 to 6 November two...

Imtech Marine Group shows whole ship solutions at Fort Lauderdale International Boat Show (August 17 2009)

At the Fort Lauderdale International Boat Show three companies...

RH Panama experiences steady business growth (July 14 2009)

RH Panama, one of the latest additions to the extensive Radio...

Imtech Marine Group offers whole ship solutions at Monaco Yacht Show (June 17 2009)

At the Monaco Yacht show four companies of the Imtech Marine...

New connectivity solution: FleetBroadband 150 (June 3 2009)

Inmarsat has launched their latest addition to the FleetBroadband...

AIS-SART - The future Search and Rescue Transmitter (June 3 2009)

Radio Holland presents the innovative AIS-SART from Jotron....

Radio Holland introduces the DMR-800LRIT terminal (June 3 2009)

Radio Holland introduces the DMR-800LRIT, a low-cost option...

Radio Holland supplies the Navi-Sailor 4000 ECDIS (June 3 2009)

Navi-Sailor 4000 ECDIS MfD is the new all-in-one product manufactured...

Radio Holland introduces the new SAILOR® 621x Series VHF (June 3 2009)

Radio Holland is pleased to introduce the SAILOR 6210 VHF, the...

Radio Holland with strong presence on Nor-Shipping 2009, stand no. B03-20 (June 2 2009)

Radio Holland, one of the world’s leading players in...

Imtech Marine Group present at Norshipping 2009, stand no. B03-20 (May 27 2009)

At Norshipping, Imtech Marine Group will show the latest technology...

34 million euro orders for technology solutions on board luxury (mega) yachts (May 6 2009)

Imtech has recently acquired orders from various ship owners...

Radio Holland opens 62nd office in Oakland, USA (April 8 2009)

Radio Holland Group announces the official opening of a new...

Radio Holland South Africa and Pertec: combining expertise in maritime electronics (February 27 2009)

Beginning of 2008 Pertec Pty Ltd. became part of the global...

New Sailor System 5000 GMDSS Consoles introduced! (February 10 2009)

We are pleased to introduce the new and updated Thrane &...

Iridium Satellite OpenPort – Communications for Maritime Markets (February 10 2009)

The introduction of this new service was delayed for two months,...

New Radio Holland Office in China (February 9 2009)

We are proud to advise that Radio Holland China has now opened...

Sailor FleetBroadband: A New Era in maritime communications (February 1 2009)

With the Sailor 500 and 250 FleetBroadband, the next generation...

Seacoast now part of Radio Holland USA: One company, one brand (January 23 2009)

Radio Holland Group announces that per 15th January 2009, the...

New Radio Holland service location in United Kingdom (January 15 2009)

Imtech Marine Group and Radio Holland Group announce that as...