News

CQWP_Query: SELECT TOP 75 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( '11082' ,0 ) ) AND hiddenchild <> 1 -- Parent = 11082 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: orders worth 38 million euro to upgrade naval vessels (November 23 2009)

Order for ‘green’ technology on board Greenpeace’s ‘Rainbow Warrior III’ (November 17 2009)

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

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

The Board of Management of Imtech (technical services provider...

Van Berge Henegouwen Installaties announces partnerships for new yachting IP solutions (October 2 2009)

Van Berge Henegouwen Installaties announces two valuable new...

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

Imtech Marine Group at Europort Maritime (September 7 2009)

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

Passing away of Harry Siertsema (August 6 2009)

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

At the Monaco Yacht show (23-26 September) four companies of...

Energy saving solution Imtech successful (May 28 2009)

With the recently signed contract for the RRS system on the...

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

IMG will be at the Norshipping exhibition in Oslo. At Norshipping,...

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

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

New order for energy-saving technology on board new cruise ship (April 22 2009)

Imtech has received an order from Meyer Werft, a German ship...

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

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

Falcon: clear view on the future (April 6 2009)

RH introduces the Falcon-line at the Construction & Shipping...

Amels and Imtech celebrate partnership with first cables pulled onboard the first LIMITED EDITIONS AMELS 212 superyacht (March 3 2009)

Imtech Marine & Offshore Ltd. moves to new offices in Monkton (February 23 2009)

Marine electrical system integration contractor Imtech Marine...

Imtech to equip new frigates of type 125 with HVAC systems (February 5 2009)

Imtech has been awarded the contract by the F125 work group...

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

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

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

A new Radio Holland service location in the southern part of...

Imtech to fit out first TUI cruise liner (January 15 2009)

Imtech Deutschland is to play a part in refitting the first...