MSSQL 存储过程必须声明变量

2024-01-10 17:22:43 297 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

U盘重装Win10系统准备工作准备一个8G或8G以上U盘（32G以内）请备份好u盘里的资料，在制作过程中会格式化硬盘请备份好要安装系统的盘的资料，安装时也会对该盘内容进行格式化。将u盘插入电脑usb接口中，尽可能的插入usb3.0的接口，这样下载和安装速度会更快。 1.到微软官网下载安装包浏览器输入：微软官网下载win10 懒人请复制粘贴：https://www.microsoft.com/zh-cn/software-download/windows10 打开之后的界面： 2.下载Media Creat. 阅读详情

ALTER PROCEDURE [dbo].[facst_2024_01_Filter_Product_Type]
@customer VARCHAR(MAX)

AS
BEGIN
DECLARE @Filter_product_type VARCHAR(MAX), @YM VARCHAR(MAX),@WHERE_product_type VARCHAR(MAX);
DECLARE @WHERETOP1 VARCHAR(MAX), @WHERETOP2 VARCHAR(MAX), @WHERETOP3 VARCHAR(MAX);
DECLARE @versions1 VARCHAR(MAX), @versions2 VARCHAR(MAX), @versions3 VARCHAR(MAX);
DECLARE @TOP1 VARCHAR(MAX), @TOP2 VARCHAR(MAX);
SET @TOP1 = '1';
SET @TOP2 = '2';
SET @versions1 =
(
SELECT TOP 3 versions
FROM
(
SELECT versions,
ROW_NUMBER() OVER(
ORDER BY versions DESC) no
FROM [RS_SYS002].[dbo].[V_FCAST_TEST]
GROUP BY versions
) A
WHERE A.no = @TOP1
);
SET @versions2 =
(
SELECT TOP 3 versions
FROM
(
SELECT versions,
ROW_NUMBER() OVER(
ORDER BY versions DESC) no
FROM [RS_SYS002].[dbo].[V_FCAST_TEST]
GROUP BY versions
) A
WHERE A.no = @TOP2
);
SET @WHERETOP1 = 'versions=' + @versions1;
SET @WHERETOP2 = 'versions=' + @versions2;
SET @WHERETOP3 = 'versions=''20231130''' ;
SET @WHERE_product_type = 'table0.customer in (@customer)'
SET @YM =
(
SELECT MIN(YM) ym
FROM [V_FCAST_TEST] A
WHERE A.versions = @versions1
GROUP BY A.versions
);

SET @Filter_product_type ='SELECT DISTINCT (table0.product_type)product_type
FROM
(
SELECT 1 AS Order_by_ID,
[Customer],
[Product_Type],
[Sales]
FROM [RS_SYS002].[dbo].[V_FCAST_TEST]
WHERE versions = ''' + @versions1 + '''
UNION
SELECT 1 AS Order_by_ID,
[Customer],
[Product_Type],
[Sales]
FROM [RS_SYS002].[dbo].[V_FCAST_TEST]
WHERE versions = ''' + @versions2 + '''
UNION
SELECT 1 AS Order_by_ID,
[Customer],
[Product_Type],
[Sales]
FROM [RS_SYS002].[dbo].[V_FCAST_TEST]
WHERE versions = ''' + @versions3 + '''
) TABLE0
where ' + @WHERE_product_type + ''
EXEC (@Filter_product_type)
END