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