bigdatademo8.sql

来自「T-SQL示例大全」· SQL 代码 · 共 29 行

/* 文件名称: BigDataDemo8.sql */
USE 北风贸易
GO

DECLARE @ptrval varbinary(16)

DECLARE @TmpTable TABLE
(
员工编号 int NOT NULL,
姓名 nvarchar(20) NOT NULL,
销售总金额 money NOT NULL
)

INSERT @TmpTable
    SELECT TOP 1
           a.员工编号,
           a.姓名 AS 业务员姓名,
           SUM(c.单价 * c.数量*(1 - c.折扣)) AS 销售总金额
      FROM 员工 a
           INNER JOIN 订货主档 b ON a.员工编号 = b.员工编号
           INNER JOIN 订货明细 c ON b.订单号码 = c.订单号码
      GROUP BY a.员工编号,a.姓名
      ORDER BY 3 DESC

SELECT @ptrval = TEXTPTR(附注) FROM 员工 
    WHERE 员工编号 = (SELECT 员工编号 FROM @TmpTable)

READTEXT 员工.附注 @ptrval 0 0