无效的对象名称#TargetDateTblx [英] Invalid Object Name #TargetDateTblx

问题描述

我有以下存储过程。当我在SQL Management Studio中执行它时，它运行正常并返回所需的结果。但是当我尝试在MS Visual Studio 2010中创建一个数据集（我将通过拖动表适配器创建）时，它会说无效对象名称#TargetDateTblx。以下是我的代码：

Hi, i have the following stored procedure. When i execute it in SQL Management Studio, it runs fine and return the desired results. But when i try to create a dataset(which i will create by dragging a table adapter) in MS Visual Studio 2010, it will say Invalid Object Name #TargetDateTblx. Below are my codes:

CREATE PROCEDURE [dbo].[CZ_SummaryCustomerNameDeliveryStatus] 

AS
BEGIN
	SET NOCOUNT ON;
DECLARE @SQL NVARCHAR(MAX)

SET @SQL = 
'	
	CREATE TABLE #TargetDateTblx(IssueID VARCHAR(100), TargetDate VARCHAR(100))
	INSERT [#TargetDateTblx]
	SELECT issueid, [fielddata] AS TargetDate
	FROM rndbug.dbo.gemini_customfielddata
	WHERE customfieldid = 215 AND LEN(fielddata) > 0			


	CREATE TABLE #ActualDateTblx(IssueID VARCHAR(100), ActualDate VARCHAR(100))
	INSERT [#ActualDateTblx]
	SELECT issueid, [fielddata] AS ActualDate
	FROM rndbug.dbo.gemini_customfielddata
	WHERE customfieldid = 217				


	CREATE TABLE #CompleteRateTblx(IssueID VARCHAR(100), CompleteRate VARCHAR(100))
	INSERT [#CompleteRateTblx]
	SELECT issueid, [fielddata] AS CompleteRate
	FROM rndbug.dbo.gemini_customfielddata
	WHERE customfieldid = 234  AND fielddata = 100


	CREATE TABLE #CustomerNamess(IssueID VARCHAR(100), CustName VARCHAR(50))
	INSERT [#CustomerNamess]
	SELECT issueid, [fielddata] AS CustName
	FROM rndbug.dbo.gemini_customfielddata
	WHERE customfieldid = 200


	CREATE TABLE #SummaryTbl(YEARS VARCHAR(100), January VARCHAR(100), February VARCHAR(100),March VARCHAR(100), April VARCHAR(100), May VARCHAR(100),June VARCHAR(100), July VARCHAR(100), August VARCHAR(100),September VARCHAR(100),October VARCHAR(100), November VARCHAR(100),December VARCHAR(100), Total VARCHAR(100))
	INSERT [#SummaryTbl] 
	SELECT
	YEARS,
	[1] AS January,
	[2] AS February,
	[3] AS March, 
	[4] AS April,
	[5] AS May,
	[6] AS June,
	[7] AS July, 
	[8] AS August,
	[9] AS September,
	[10] AS October,
	[11] AS November,
	[12] AS December, 
	[1]+[2]+[3]+[4]+[5]+[6]+[7]+[8]+[9]+[10]+[11]+[12] [Total]
	FROM(
	SELECT CustName, SUBSTRING(ActualDate, 5, 1) AS Months, SUBSTRING(ActualDate, 7, 4) AS YEARS 
	FROM #CustomerNamess C
	LEFT JOIN #ActualDateTblx A
	ON C.IssueID = A.IssueID
	LEFT JOIN #CompleteRateTblx O
	ON C.IssueID = O.IssueID
	WHERE CompleteRate = 100 AND LEN(SUBSTRING(ActualDate, 7, 4))=4 
	)TableDate
	
	PIVOT
	(
		COUNT (CustName) FOR Months IN ([1], [2], [3], [4], [5], [6], [7],[8],[9],[10],[11],[12])
	) PIVOTCOUNT  
	
	SELECT * FROM #SummaryTbl
	'
	
	
SELECT @SQL = @SQL
EXEC sp_executesql @SQL

END

推荐答案

这篇关于无效的对象名称#TargetDateTblx的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！