select top 1 pagedetailid,convert(VARCHAR(11),TopicDate,106) as TopicDate,photoid,Description,imagename,[language],topicheading,topicdescription from View_PhotoNews where topicdate<=getdate()and PageDetailId!=17759and PageId=21 order by topicdate desc,newid(),PageDetailId desc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)