TEMP TABLE NOT WORKING

In query analyzer the correct data is returned.

But when I run it in my application no records ae displayed.

In Sql profiler it says completed and I use the values in query analzyer it works fine. here is my stored proc:

CREATE PROCEDURE [dbo].oc_OnlineCaseOrder

@CategoryId int,
@Order varchar(25)

As

SET @CategoryId = @CategoryId
SET @Order = @Order

If @Order = 'Alpha'

Begin

SELECT
oc.[CaseId],
oc.[StatusId],
oc.[CategoryId],
oc.[Title],
oc.[CaseText],
oc.CourseId,
occ.Description AS CategoryDescription,
ocs.Description AS StatusDescription
FROM
[dbo].oc_OnlineCase oc WITH (nolock)
JOIN dbo.oc_OnlineCaseCategory occ WITH (nolock) ON oc.CategoryId = occ.CategoryId
JOIN dbo.oc_OnlineCaseStatus ocs WITH (nolock) ON oc.StatusId = ocs.StatusId
WHERE oc.CategoryId = ISNULL( @CategoryId, oc.CategoryId )
AND oc.StatusId = 100
Order by oc.[Title]

END

ELSE

Begin

DECLARE @TempCaseIds Table
(
CaseId int,
CategoryDescription varchar(30)
)

SELECT MIN(oca.AuditDate) as "Recent Case Publication", oca.CaseId, occ.[Description]
INTO #TempCaseIds
From
[dbo].oc_OnlineCaseAudit oca WITH (nolock)
JOIN dbo.oc_OnlineCase oc WITH (nolock) ON oc.CaseId = oca.CaseId
JOIN dbo.oc_OnlineCaseCategory occ WITH (nolock) ON oc.CategoryId = occ.CategoryId
JOIN dbo.oc_OnlineCaseStatus ocs WITH (nolock) ON oc.StatusId = ocs.StatusId
WHERE oc.CategoryId = ISNULL( @CategoryId, oc.CategoryId )
AND oc.StatusId = 100
Group by oca.CaseId,occ.[Description]

Select DISTINCT
CaseId, [Description]
From #TempCaseIds

End


GO