Welcome to WSRadio!

Conversion failed when converting date and/or time from character string.
select p.etitle as title,p.edesc as cdesc,c.showname as stitle,c.hostshow,case when c.showcat='0' then '' else c.showcat end as showcatws,'http://admin.businessleader.com/imagesblr/'+c.showlogos as showlogos1,case when stitle1<>'' and stitle1 is not null then '

01: '+stitle1+'

' else '' end as slink11,case when stitle2<>'' and stitle2 is not null then '

02: '+stitle2+'

' else '' end as slink21,case when stitle3<>'' and stitle3 is not null then '

03: '+stitle3+'

' else '' end as slink31,case when stitle4<>'' and stitle4 is not null then '

04: '+stitle4+'

' else '' end as slink41,'http://wsradio.com/show_Archives.aspx?id='+Convert(varchar,p.eid) as slink from postepisode p,createshow c where p.sid=c.sid and p.sid=10 and p.sdate='selected' order by CONVERT(datetime,CONVERT(varchar,sdate,101)+' '+rtrim(replace(SUBSTRING(p.stime,0,8),'-',''))) desc Welcome to WSRadio!