Imtech Marine Group

A World of Support

• Imtech Marine Group

• Home
• Company
• Products
• Projects
• Service
• Connectivity
• News

News

• All items
• 2010
• 2009
• 2008
• 2007
• 2006

CQWP_Query: SELECT TOP 50 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 , 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( '16600' ,0 ) ) -- Parent = 16600 Order by Isnull(showfrom, addDate) DESC