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
, 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( '16600' ,0 ) )
-- Parent = 16600
Order by Isnull(showfrom, addDate) DESC
At SMM, Imtech Marine will present a unique live satellite connection...
Imtech is observing a recovery of the technological maritime...
At the Offshore Technology Conference in Houston, United States...
Radio Holland USA (Houston, TX) – Radio Holland USA has...
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...
At the upcoming Marintec exhibition from 1 to 4 December, Imtech...
The Board of Management of Imtech announces the appointment...
FT NavVision® is a powerful modular conning, monitoring &...
At the Fort Lauderdale International Boat Show three companies...
Having the very best service levels possible is a key part of...
In August 2009, Radio Holland signed an agreement for the VSAT...
At the upcoming Europort exhibition from 3 to 6 November two...
At the Fort Lauderdale International Boat Show three companies...
RH Panama, one of the latest additions to the extensive Radio...
At the Monaco Yacht show four companies of the Imtech Marine...
Inmarsat has launched their latest addition to the FleetBroadband...
Radio Holland presents the innovative AIS-SART from Jotron....
Radio Holland introduces the DMR-800LRIT, a low-cost option...
Navi-Sailor 4000 ECDIS MfD is the new all-in-one product manufactured...
Radio Holland is pleased to introduce the SAILOR 6210 VHF, the...
Radio Holland, one of the world’s leading players in...
At Norshipping, Imtech Marine Group will show the latest technology...
Imtech has recently acquired orders from various ship owners...
Radio Holland Group announces the official opening of a new...
Beginning of 2008 Pertec Pty Ltd. became part of the global...
We are pleased to introduce the new and updated Thrane &...
The introduction of this new service was delayed for two months,...
We are proud to advise that Radio Holland China has now opened...
With the Sailor 500 and 250 FleetBroadband, the next generation...
Radio Holland Group announces that per 15th January 2009, the...
Imtech Marine Group and Radio Holland Group announce that as...
Radio Holland Netherlands BV has been appointed by the Dutch...
Radio Holland brings you Broadband internet services with voice...
On 8 October the Radio Holland Group (Rotterdam) signed a contract...
Transas Benelux and Radio Holland Netherlands renewed the Dealer...
At the world’s largest marine exhibition, SMM Hamburg...
Following on from the DM300 S-VDR and DM500 VDR, the new and...
In September 2008 Iridium finally launched their new maritime...
Radio Holland's Global Service House is proud to introduce an...
Beluga Shipping, based in Bremen, is a world market leader in...
On August 19 2008 Inmarsat finally succeeded together with their...
Imtech, een van ‘s werelds grootste en snelst groeiende...
Radio Holland Group announced that they selected Key Equipment...
At the Monaco Yacht show, three companies who are part of Imtech...
The new SOLAS regulation on long-range identification and tracking...