【6】齐鲁医院保健体检

WITH RankedItems AS (
SELECT
order_item_id,
ROW_NUMBER() OVER (ORDER BY order_item_sort, order_item_id) + 99 AS new_sort
FROM a_dic_order_item
WHERE order_item_exe_dept = '科室编码'
AND organization_id = '组织ID'
)
UPDATE a_dic_order_item
SET order_item_sort = r.new_sort
FROM a_dic_order_item t
INNER JOIN RankedItems r ON t.order_item_id = r.order_item_id
WHERE t.order_item_exe_dept = '科室编码'
AND t.organization_id = '组织ID';
语句含义：将某个科室下的检查项目从99 开始累加 然后修改排序