已有存储过程:
CREATE PROCEDURE UP_PM_YueBaoGetCaimeiDepAS
SELECT DepName, DepID
FROM PM_Department
WHERE DepType = "采煤"
ORDER BY DepID ASC
GO现在我想使另外一个表PM_MineMonthPlan中的MineMonthPlanDepartmentID 和 PM_Department中的DepID相等的情况下,从表PM_MineMonthPlan中查询得到MineMonthPlanMonthPlan这个字段的所有记录,请高手指点这个存储过程该怎么写?
CREATE PROCEDURE UP_PM_YueBaoGetCaimeiDepAS
SELECT DepName, DepID
FROM PM_Department
WHERE DepType = "采煤"
ORDER BY DepID ASC
GO现在我想使另外一个表PM_MineMonthPlan中的MineMonthPlanDepartmentID 和 PM_Department中的DepID相等的情况下,从表PM_MineMonthPlan中查询得到MineMonthPlanMonthPlan这个字段的所有记录,请高手指点这个存储过程该怎么写?
as
select b.MineMonthPlanMonthPlan from PM_Department a ,PM_MineMonthPlan b where a.DepID=b.MineMonthPlanDepartmentID
from PM_Department a join
PM_MineMonthPlan b on a.DepID=b.MineMonthPlanDepartmentID
将存储过程的结果插入到一个临时表里,然后在进行下面的操作declare @temptb table(DepName varchar(30),DepID varchar(30))
insert into @temptb exec UP_PM_YueBaoGetCaimeiDepselect MineMonthPlanMonthPlan from @temptb a inner join PM_MineMonthPlan b
on a.DepID=b.MineMonthPlanDepartmentID
CREATE PROCEDURE UP_PM_YueBaoGetMineMonthPlanMonthPlanAS
SELECT MineMonthPlanMonthPlan
FROM PM_MineMonthPlan ,PM_Department
WHERE MineMonthPlanDepartmentID =DepID
ORDER BY DepID ASC
GO