News
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
,
RTRIM(SUBSTRING(Isnull(CTSpecificTextIm1, description), 1, (CHARINDEX(' ', Isnull(CTSpecificTextIm1, description) + SPACE(60), 60)))) as ShortDescription,
ShortDescriptionSuffix = CASE WHEN (LEN(Isnull(CTSpecificTextIm1, description)) >= 60 AND 1 = 1) THEN '...' ELSE '' END
FROM vwActive_DEF
WHERE
Nr IN (Select nr from dbo.fn_RecurseChildren( '11082' ,0 ) )
-- Parent = 11082
Order by Isnull(showfrom, addDate) DESC
Imtech Schiffbau-/Dockbau-technik, headquartered in Hamburg/Germany,...
Imtech (technical services provider in Europe) is celebrating...
Radio Holland Connect introduces the VSAT Prepaid Calling Card....
Imtech has been awarded a design & build contract for the...
Radio Holland Group announces the official opening of a new...
The Board of Management of Imtech (technical services provider...
Van Berge Henegouwen Installaties announces two valuable new...
At the Monaco Yacht show (23-26 September) four companies of...
With the recently signed contract for the RRS system on the...
IMG will be at the Norshipping exhibition in Oslo. At Norshipping,...
Imtech has recently acquired orders from various ship owners...
Imtech has received an order from Meyer Werft, a German ship...
Radio Holland Group announces the official opening of a new...
RH introduces the Falcon-line at the Construction & Shipping...
Marine electrical system integration contractor Imtech Marine...
Imtech has been awarded the contract by the F125 work group...
Radio Holland Group announces that per 15th January 2009, the...
A new Radio Holland service location in the southern part of...
Imtech Deutschland is to play a part in refitting the first...
On Thursday 23 October the Alderman of Economics, Harbour and...
As of 1st November Pieter Bloemendaal will become Managing Director...
On 8 October the Radio Holland Group (Rotterdam) signed a contract...
Imtech announces that it has been commissioned to provide the...
Radio Holland Group announces that they selected Key Equipment...
As from 1 May 2008 Guido Speelman assumed the function of General...
At the Monaco Yacht show (24-27 September), three companies...
Tijdens ’s werelds grootste maritieme beurs, SMM Hamburg...
Meyer Werft has awarded Imtech Deutschland the title of “Partner...
Imtech announces that it has been commissioned to provide solutions...
Imtech (technical services provider in Europe and the global...
Luxury yachts portfolio expanded to include high-tech multimedia...
Imtech announces that it has expanded its maritime service network...
Recently Imtech Marine & Offshore (IM&O) celebrated...
Imtech (technical services provider in Europe) announces that...
In December 2007 Radio Holland installed and commissioned the...
Radio Holland, a globally renowned maritime electronics solutions...
Radio Holland will be present at the upcoming edition of Europort...