sql:选择时没有结果，结果出错
提问于 2014-01-02 01:28:20
好的，在执行以下代码时，我遇到了一个问题:显示“成功完成的命令”，但我的SELECT问题1没有结果，而且当单独执行时，它也会工作，但是结果会一直改变*问题2* e.g result1: 10:41再次执行20:82。我只需要10点41分(*我在数有多少份“工作”是开放和关闭的)
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[p_GetSocre]
@AUD_ID BIGINT,
@RowCounter BIGINT,
@DistinctCounter BIGINT,
@NACounter BIGINT,
@Total BIGINT,
@Status NVARCHAR(10)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
CREATE TABLE #tmp1
(
AUD_ID BIGINT,
RowCounter BIGINT,
DistinctCounter BIGINT,
NACounter BIGINT,
Total BIGINT,
[Status] VARCHAR(MAX)
)
INSERT INTO #tmp1
EXEC [p_GetCompleteIncompleteNaOverviewSCORE]
END
SELECT [Status] AS [Open/Closed], COUNT(*) AS [Status] FROM #tmp1
GROUP BY [Status]
--DROP TABLE #tmp1另一个存储的proc p_GetCompleteIncompleteNaOverviewSCORE只在任务的所有部分都完成之前才计算它是否处于打开/关闭状态。
谢谢
回答 1
Stack Overflow用户
回答已采纳
发布于 2014-01-02 01:40:49
请试试下面..。不需要删除临时表，因为Proc会自动删除临时表。
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[p_GetSocre]
@AUD_ID BIGINT,
@RowCounter BIGINT,
@DistinctCounter BIGINT,
@NACounter BIGINT,
@Total BIGINT,
@Status NVARCHAR(10)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
CREATE TABLE #tmp1
(
AUD_ID BIGINT,
RowCounter BIGINT,
DistinctCounter BIGINT,
NACounter BIGINT,
Total BIGINT,
[Status] VARCHAR(MAX)
)
INSERT INTO #tmp1
EXEC [p_GetCompleteIncompleteNaOverviewSCORE]
SELECT [Status] AS [Open/Closed], COUNT(*) AS [Status] FROM #tmp1
GROUP BY [Status]
END页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/20879838
复制相关文章
腾讯云开发者
