A
Andrew Cooper
Greetings,
I'm creating a website using ASP.NET. In creating my DAL I've got a
Table Adapter that I've set up to use an existing Stored Procedure from
an SQL Server 2000 database. However, when I select the stored
procedure I want to use the fields that are returned do not show up in
the listbox for that stored procedure. If I continue and attempt to
finish the Table Adapter I get the following error (even though the
Adapter is created)...
"Generated Select Statement.
Invalid object name #TempNoPatch."
Here is the entire stored procedure that I'm attempting to connect to.
<--- Begin code ---->
create procedure Monthly_Billing_Report
@StartDate varchar(10),
@EndDate varchar(10)
as
exec usp_Billing_Report_by_Main @StartDate, @EndDate
select MainAcctNum, MainAcctName, AutoAttnTime, OperatorTime, PatchTime,
NumCalls from MonthlyBillingReport
<--- End Code --->
Essentially, it fills a table in the database and then returns that
table. The #TempNoPatch is a temporary table used in the
usp_Billing_Report_by_Main procedure. Why is the Adapter getting hung
up on the temp table in the second procedure? I'm just returned an
actual table that is defined in the database. You would think it'd know
what the results would look like from that.
Thanks,
Andrew
I'm creating a website using ASP.NET. In creating my DAL I've got a
Table Adapter that I've set up to use an existing Stored Procedure from
an SQL Server 2000 database. However, when I select the stored
procedure I want to use the fields that are returned do not show up in
the listbox for that stored procedure. If I continue and attempt to
finish the Table Adapter I get the following error (even though the
Adapter is created)...
"Generated Select Statement.
Invalid object name #TempNoPatch."
Here is the entire stored procedure that I'm attempting to connect to.
<--- Begin code ---->
create procedure Monthly_Billing_Report
@StartDate varchar(10),
@EndDate varchar(10)
as
exec usp_Billing_Report_by_Main @StartDate, @EndDate
select MainAcctNum, MainAcctName, AutoAttnTime, OperatorTime, PatchTime,
NumCalls from MonthlyBillingReport
<--- End Code --->
Essentially, it fills a table in the database and then returns that
table. The #TempNoPatch is a temporary table used in the
usp_Billing_Report_by_Main procedure. Why is the Adapter getting hung
up on the temp table in the second procedure? I'm just returned an
actual table that is defined in the database. You would think it'd know
what the results would look like from that.
Thanks,
Andrew