本文介绍了SQL查询功能的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我想要这个存储过程的SQL查询
I want, SQL query for this stored procedure
CREATE PROCEDURE GetJobReceivedBeyondPC
(
@JobReceivedBeyondPC float output,
)
AS
BEGIN
declare @countJobsDateDiff float
declare @countProdcutivityCapacity float
declare @SumFootage float
select @countJobsDateDiff= query
select @countProdcutivityCapacity = count() from
select @SumFootage = sum(footage) from
@JobReceivedBeyondPC = (JobDate*@countProdcutivityCapacity)<@SumFootage
END推荐答案
这篇关于SQL查询功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！