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_RHD
WHERE
Nr IN (Select nr from dbo.fn_RecurseChildren( '16600' ,0 ) )
AND hiddenchild <> 1
-- Parent = 16600
AND DATEPART(yyyy,ISNULL(ShowFrom,Adddate)) = 2006
Order by Isnull(showfrom, addDate) DESC
On 6 December 2006 Radio Holland Group (Rotterdam) celebrated...
During SMM 2006, Jakob Hatteland Display (JHD), the world leading...
Broadband services are ideal for ocean going vessels that require...
On 8 August, Radio Holland Group opened the newest addition...
International maritime electronics expert Radio Holland is present...
Thrane & Thrane A/S, equipment manufacturer of whom Radio...
Since the Management Buy Out of the Radio Holland Group in 2002,...
Radio Holland Group and Imtech announce that the intended acquisition...
On Thursday 27th April 2006, six young people from across the...
