阅读背景:

错误消息获取子查询返回的值超过1。这个查询中的错误是什么

来源:互联网 
INSERT INTO [BOOnboardingStatus]
            (BusinessID,
             SectionID,
             SectionName,
             SubSectionID,
             SubSectionName,
             status,
             createdby,
             modifieddate,
             modifiedby,
             source,
             createddate)
SELECT contentid,
       2,
       'Additional Info',
       '22',
       'Add keywords',
       (SELECT CASE
                 WHEN categoryname IS NOT NULL THEN 1
                 ELSE 0
               END
        FROM   businesscategory
        WHERE  businessid IN(SELECT contentid
                             FROM   businessmaster
                             WHERE  isclaim = 1)
               AND [primary] = 1),
       1,
       Getdate(),
       0,
       'BOD',
       Getdate()
FROM   businessmaster
WHERE  isclaim = 1 
INSERT INTO [BOOnboardingStatus]
            (B



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: