Projects
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( '11084' ,0 ) )
-- Parent = 11084
Order by Sortindex
Imtech Marine Group has been commissioned to supply the entire...
Twizzle, a 56 metres long luxury mega-yacht, built by De Vries...
The cruise ship Celebrity Solstice required a sophisticated...
The summer of 2007 a unique offshore vessel will set sail. With...
Recently HDW-Hagenuk Schiffstechnik GmbH Hamburg (HST), part...
Radio Holland Netherlands booked a global Frame Agreement with...
