雇员主文件_工资汇总_proc.sql

SQL server 进销存软件数据库设计。大家积极下载

if exists(select name from sysobjects where name='雇员主文件_工资汇总_PROC' and type= 'p')
drop PROC 雇员主文件_工资汇总_PROC
GO 
CREATE PROC 雇员主文件_工资汇总_PROC

@DEPT_TO  varchar (10),
@DEPT_FR  varchar (10)
AS
CREATE TABLE #雇员主文件(

	[雇员码] [varchar] (10),
	[雇员姓名] [varchar] (10) ,
	[部门码] [varchar] (10) ,
	[部门主管] [varchar] (10) ,
	[出生年月] [datetime] ,
	[民族] [varchar] (10) ,
	[婚姻] [varchar] (10) ,
	[子女] [int] ,
	[毕业学校] [varchar] (30) ,
	[学历] [varchar] (10) ,
	[专业] [varchar] (20)  ,
	[工资标准] [numeric](18, 6) ,
	[正常工资率（元/小时] [numeric](18, 6))
	
INSERT INTO #雇员主文件 select * from 雇员主文件

SELECT 部门码,SUM(工资标准)  FROM #雇员主文件 WHERE 部门码>=@DEPT_TO AND 部门码<=@DEPT_FR GROUP BY 部门码