--%>

Search Results

Advanced Search

Error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Master: Select RF_SECTN.link,RF_SECTN.inettitle as c1,isnull(convert(varchar(10), RF_SECTN.START_DTET, 101), '') as c2,isnull( substring(convert(char(19), RF_SECTN.START_DTET, 100), 13, 5) + ' ' + right(convert(char(19), RF_SECTN.START_DTET, 100), 2), space(8)) as c3,isnull( substring(convert(char(19), RF_SECTN.END_DTET, 100), 13, 5) + ' ' + right(convert(char(19), RF_SECTN.END_DTET, 100), 2), space(8)) as c4,rtrim(RF_SECTN.INST_NAME) as c6,RF_SECTN.link as c7,rf_SECTN.REF_NOTES as c8 ,RF_SECTN.START_DTET as sort1 from RF_SECTN where RF_SECTN.link in ('6305', '6306', '6307', '6308', '6309', '6310', '6354', '6355', '6356') order by sort1

Child0: Select RF_SECTN.link as Link_Child, RF_CLASS.link as Link, CASE WHEN str((select count(*) from rf_sslot where rf_sslot.l_rf_sectn = rf_sectn.link and rf_sslot.l_sf_pop is null)) = 0 THEN 'Class Full' ELSE ' 1 and sysmsl2.ccAuthDotNet <> 1)) then case when isnull (cost_center.ccServer,'') != '' then cost_center.ccvendor when isnull (cost_center.ccServer,'') = '' and isnull (RF_SLOC.ccServer,'') != '' then RF_SLOC.ccvendor else SysMSL2.ccvendor end when sysmsl2.ccEPX=1 then case when isnull (cost_center.ccmerch_nbr,'') != '' then cost_center.ccmerch_nbr when isnull (cost_center.ccmerch_nbr,'') = '' and isnull (RF_SLOC.ccmerch_nbr,'') != '' then RF_SLOC.ccmerch_nbr else SysMSL2.ccmerch_nbr end when sysmsl2.ccAuthDotNet=1 then case when isnull(cost_center.ccAuthLogin,'') != '' then cost_center.ccAuthLogin when isnull (cost_center.ccAuthLogin,'') = '' and isnull (RF_SLOC.ccAuthLogin,'') != '' then RF_SLOC.ccAuthLogin else SysMSL2.ccauthlogin end else '' end from rf_sectn sect left outer join sysmsl3 on 1=1 left outer join sysmsl2 on 1=1 left outer join RF_CLASS on RF_CLASS.Link = sect.L_RF_CLASS left outer join RF_SLOC on RF_SLOC.Link = RF_CLASS.L_rf_sloc left outer join Cost_center on cost_center.code = sect.costcenter where sect.Link = RF_SECTN.LINK)+'")'' />' END as col1 from RF_SECTN join RF_CLASS on RF_SECTN.L_RF_CLASS=RF_CLASS.LINK and RF_CLASS.record_type = 'CLASS' where RF_SECTN.link in ('6305', '6306', '6307', '6308', '6309', '6310', '6354', '6355', '6356') Order by 1, RF_CLASS.link

Child1: Select RF_SECTN.link as Link_Child, RF_SLOC.link as Link, RTRIM(RF_SLOC.ADDRESS1) + char(13) + char(10) + case when rtrim(RF_Sloc.address2) = ' ' then '' else rtrim(RF_Sloc.address2) + char(13) + char(10) end + RTRIM(RF_SLOC.CITY)+', ' + RF_SLOC.STATE + ' ' + RTRIM(RF_SLOC.ZIP) as col1 from RF_SECTN join RF_SLOC on RF_SECTN.L_RF_SLOC=RF_SLOC.LINK and RF_SLOC.slocrec_type='CLASS' where RF_SECTN.link in ('6305', '6306', '6307', '6308', '6309', '6310', '6354', '6355', '6356') Order by 1, RF_SLOC.link


Debug: h08,h5,h50,730,755,760,765,780,785,790,795