Stored Procedure Nightmare

Greetings,I have a couple of stored procedures
that interact to deliver a resultset of data. The first one is
"spStoreList", it receives a few parameters and returns a listing of
stores in a given company or division. The source is below:CREATE PROCEDURE [DBO].[spStoreList](
@p_companyX varchar(20) = NULL,
@p_divisionX char(1) = NULL,
@p_storeX char(4) = NULL
)
AS

CREATE TABLE #Output(
 Company char(3),
 Division char(1),
 Store char(4),
 Nickname varchar(40)
)

 IF @p_companyX IS NULL
 BEGIN
  insert into #Output
  SELECT CompanyNo,Division,StoreNo,StoreNickname FROM [TBL Store]
  ORDER BY CompanyNo,Division,StoreNo
 END
 IF @p_companyX IS NOT NULL AND @p_divisionX IS NULL
 BEGIN
  insert into #Output
  SELECT CompanyNo,Division,StoreNo,StoreNickname FROM [TBL Store]
  WHERE
   CompanyNo IN (SELECT DISTINCT CompanyNo FROM [TBL Company] WHERE [TBL Company].[CompanyGroup]=@p_companyX)
  ORDER BY CompanyNo,Division,StoreNo
 END
 IF @p_companyX IS NOT NULL AND @p_divisionX IS NOT NULL AND @p_storeX IS NULL
 BEGIN
  insert into #Output
  SELECT CompanyNo,Division,StoreNo,StoreNickname FROM [TBL Store]
  WHERE
   CompanyNo IN (SELECT DISTINCT CompanyNo FROM [TBL Company] WHERE [TBL Company].[CompanyGroup]=@p_companyX) AND
   Division IN (SELECT DISTINCT DivNo FROM [TBL Division] WHERE DivNo=@p_divisionX AND [tbl Division].[CompanyNo]=[tbl Store].[CompanyNo])
  ORDER BY CompanyNo,Division,StoreNo
 END
 IF @p_companyX IS NOT NULL AND @p_divisionX IS NOT NULL AND @p_storeX IS NOT NULL
 BEGIN
  insert into #Output
  SELECT CompanyNo,Division,StoreNo,StoreNickname FROM [TBL Store]
  WHERE
   StoreNo = @p_storeX
  ORDER BY CompanyNo,Division,StoreNo
 END

SELECT * FROM #Output ORDER BY Company,Division,Store

DROP TABLE #Output
GO
The second procedure, "spEmployeeService" uses this
procedure to return a list of how many years the employees have worked
for stores that get returned in the list. THe source is here:CREATE PROCEDURE [dbo].[spEmployeeService](
@p_company char(20) = NULL,
@p_division char(1) = NULL,
@p_store char(4) = NULL
) AS

DECLARE @target int
DECLARE @newLabel varchar(30)

set @target=0

CREATE TABLE #Output(
 SortCode int,
 Label varchar(30),
 Years int
)

CREATE TABLE #Service(
 Cnt int
)

CREATE TABLE #Dock(
 SortCode int,
 Label varchar(30),
 Years int
)

create table #Stores(
 Company char(3),
 Division char(1),
 Store char(4),
 Nickname char(40)
)

insert into #Stores
exec spStoreList @p_companyX=@p_company,@p_divisionX=@p_division,@p_storeX=@p_store

insert into #Service
select
 DateDiff(yyyy,HireDate,GETDATE()) AS YearsOfService
from [tblPyoNet]
where
 terminatedate is null and
 company <> '' and
 [tblPyoNet].StoreNo IN (Select Store FROM #Stores)

insert into #Dock (SortCode,Label,Years)
select
 CASE
  WHEN Cnt <= 1 THEN 1
  WHEN Cnt = 2 THEN 2
  WHEN Cnt = 3 THEN 3
  WHEN Cnt = 4 THEN 4
  WHEN Cnt = 5 THEN 5
  WHEN Cnt = 6 THEN 6
  WHEN Cnt = 7 THEN 7
  WHEN Cnt = 8 THEN 8
  WHEN Cnt = 9 THEN 9
  WHEN Cnt = 10 THEN 10
  WHEN Cnt <= 15 AND Cnt >10 THEN 11
  WHEN Cnt >15 THEN 12
 END,
 CASE
  WHEN Cnt <= 1 THEN '1 Year'
  WHEN Cnt = 2 THEN '2 Years'
  WHEN Cnt = 3 THEN '3 Years'
  WHEN Cnt = 4 THEN '4 Years'
  WHEN Cnt = 5 THEN '5 Years'
  WHEN Cnt = 6 THEN '6 Years'
  WHEN Cnt = 7 THEN '7 Years'
  WHEN Cnt = 8 THEN '8 Years'
  WHEN Cnt = 9 THEN '9 Years'
  WHEN Cnt = 10 THEN '10 Years'
  WHEN Cnt <= 15 AND Cnt >10 THEN '11-15 Years'
  WHEN Cnt >15 THEN '> 15 Years'
 END,
 1
FROM #Service

insert into #Output
select SortCode,Label,SUM(Years) FROM #Dock GROUP BY Label,SortCode

while @target<12
begin
set @target=@target+1
 if (select count(*) from #Output where SortCode=@target) = 0
 begin
  if @target = 11
  begin
   set @newLabel = '11-15 Years'
  end
  if @target = 12
  begin
   set @newLabel = '> 15 Years'
  end
  else
  begin
   set @newLabel = STR(@target)+' Years'
  end
  insert into #Output (SortCode,Label,Years) VALUES(@target,@newLabel,0)
 end
end

SELECT * FROM #Output ORDER BY SortCode

DROP TABLE #Stores
DROP TABLE #Dock
DROP TABLE #Service
DROP TABLE #Output
GO
I can get these two procedures to work in Query Analyzer,
but if I try to pull pack a datatable in ASP.NET I get the following
error:ERROR:Invalid column name 'Store'. Invalid column name
'Division'. Invalid column name 'Company'. Insert Error: Column name or
number of supplied values does not match table definition. Insert
Error: Column name or number of supplied values does not match table
definition. Insert Error: Column name or number of supplied values does
not match table definition. Insert Error: Column name or number of
supplied values does not match table definition.
Any ideas why this would work in Query
Analyzer and not in .NET. By the way, I send the following SQL to an
SQLOLEDB driver, "exec spEmployeeService 'EFS','B'" to be returned in a
datatable.Help is appreciated.