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
AND DATEPART(yyyy,ISNULL(ShowFrom,Adddate)) = 2011
Order by Isnull(showfrom, addDate) DESC
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....
