1. 转品牌历史问题处理优化
2. 刷转品牌数据
任务描述
1. 转品牌历史问题处理优化
2. 刷转品牌数据
| 所属迭代 | 技术研发中心 11月运维事项（2022年） |
|---|---|
| 所属模块 | / |
| 相关需求 | 暂无 |
| 指派给 | Closed 于 2022-11-28 14:59:29 |
| 任务类型 | 运维 |
| 任务标签 | 初始 |
| 开发组 | 敏捷开发组 |
| 任务状态 | 已关闭 |
| 进度 | 100% |
| 优先级 | P2 |
| 关键词 | |
| 抄送给 |
| 由谁创建 | 何建宝 于 2022-11-22 18:14:36 |
|---|---|
| 由谁完成 | 邹声全 于 2022-11-23 11:24:20 |
| 由谁取消 | 暂无 |
| 由谁关闭 | zhengqiao 于 2022-11-28 14:59:29 |
| 关闭原因 | 已完成 |
| 最后编辑 | zhengqiao 于 2022-11-28 14:59:29 |
| 团队 | 最初预计 | 总计消耗 | 预计剩余 |
|---|
| 最初预计 | 3工时 |
|---|---|
| 总计消耗 | 3工时 |
| 预计剩余 | 0工时 |
| 预计开始 | 2022-11-22 |
| 实际开始 | 2022-11-23 |
| 截止日期 | 2022-11-22 |
转品牌历史问题处理
处理sql：
UPDATE p
SET p.ReceiptRemark = t3.ReceiptRemark + t3.BorrowSampleMemo
FROM RB_Product p
INNER JOIN
(
SELECT *
FROM
(
SELECT *,
CHARINDEX(t.BrandName, t.ReceiptRemark) IsContains
FROM
(
SELECT p.id,
tm.BrandSKU,
tm.SKU,
ta.BorrowSampleMemo,
pb.BrandName,
p.ReceiptRemark,
p.AddTime
FROM RB_Product p
INNER JOIN RB_TransformBrand_Main tm
ON p.CustomerID = tm.CustomerID
AND p.SKU = tm.BrandSKU
INNER JOIN RB_TransformBrand_Admin ta
ON tm.ID = ta.PutforwardID
AND tm.SKU = ta.SKU
INNER JOIN RB_Product_Brand pb
ON p.BrandID = pb.ID
WHERE p.SKU IN ( '15727444', '15666932', '15666873', '15666872', '15666857', '15663245', '15663244',
'15663238', '15663236', '15663235', '15588024', '15588020', '15503776', '15503770',
'15503767', '15503746', '15503743', '15503738', '15503788', '15403028', '15403022',
'15403021', '15403010', '15402996', '15402995', '15046892', '15402985', '14975540',
'14895807', '15402982', '14833706', '14833702', '14833696', '14895779', '14793170',
'14793167', '14793160', '14649957', '14649955', '14649953', '14649950', '14629472',
'14580266', '14629459', '14493435', '14493433', '14424329', '14493424', '14372980',
'14372977', '14424321', '14372970', '14313516', '14313512', '14313499', '14313495',
'14164277', '14164273', '14164272', '14313483', '14106231', '14106228', '14106225',
'14106222', '14313481', '14164248', '14164247', '14033476'
)
--order by p.AddTime
) t
) t2
WHERE t2.IsContains = 0
--order by t2.AddTime asc
) t3
ON p.id = t3.ID;