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
Order by Isnull(showfrom, addDate) DESC
Venteville BV levert systemen voor ballastwater treatment en...
Imtech Marine has been awarded a contract to supply the hybrid...
Imtech Marine heeft de opdracht gekregen voor het ontwerp, de...
Imtech Marine will be present at Europort 2011 (8-11 November,...
Imtech N.V. maakt bekend dat Imtech Marine als technologiepartner...
Air conditioning systems require regular maintenance. On ships...
Imtech Marine announces the opening of a new office in the Algeciras-Strait...
Imtech N.V. maakt bekend dat Hare Majesteit de Koningin der...
Imtech N.V. maakt bekend dat het de maritieme onderneming Groupe...
Imtech ziet een duidelijke groei in het aantal door Imtech beheerde...
Imtech Marine, developed an IPTV based crew entertainment solution...
Pole Star and Radio Holland signed a Distributor contract to...
Radio Holland Connect, the connectivity competence center of...
Recently Imtech received the order for Amels build number 6503,...
West Coast Shipyard-led Team to Highlight World-Class Resources,...
Imtech Marine will launch its modular and flexible concept “Multiflex"....
Imtech Marine, through its member Radio Holland, is the first...
The renowned VHF Sailor RT-2048 VHF that has been in the market...
Imtech Marine France will be present at the Antibes Yacht Show,...
Imtech Marine announces its new 2011 - 2015 growth strategy....
Imtech Schiffbau-/Dockbautechnik has been awarded a contract...
Radio Holland Netherlands and Spliethoff’s Bevrachtingskantoor...
Imtech heeft orders ontvangen voor nieuwe en bestaande schepen...
Imtech Marine is present at the oil & gas industry exhibition...
At SMM, Imtech Marine will present a unique live satellite connection...
Imtech is observing a recovery of the technological maritime...
On 24th June, Imtech Marine & Offshore organised an event...
With the Zero Emission Ships initiative Imtech Marine Group...
Imtech has developed a new Electronic Chart Display and Information...
Imtech Marine Group has appointed Arjan Kleinveld as Managing...
Radio Holland USA (Houston, TX) – Radio Holland USA has...
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....
Radio Holland Group announces the official opening of a new...
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,...
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...