Stored Procedure Execution Problem

hi guys

I am having problems running a stored procedure where i am using two input parameters

my stored procedure is as follows

ALTER procedure [dbo].[enterdhbnameDhbService]

(

@dhb_service char, @dhbname char

)

as

SELECT dbo.DHBMappingTable.[DHB Name], dbo.Agency.DHB_service, dbo.PurchaseUnitMappingTable.PU,

SUM(dbo.[NMDS Data for IDF Report].[Number of caseweighted discharges]) AS Expr1, dbo.AdmissionMappingTable.Admission

FROM dbo.DomicileCodes INNER JOIN

dbo.[NMDS Data for IDF Report] ON dbo.DomicileCodes.[Domicile code] = dbo.[NMDS Data for IDF Report].[Domicile Code] INNER JOIN

dbo.PurchaseUnitMappingTable ON dbo.[NMDS Data for IDF Report].[Purchase Unit] = dbo.PurchaseUnitMappingTable.PU INNER JOIN

dbo.AdmissionMappingTable ON

dbo.[NMDS Data for IDF Report].[Admission Type Description] = dbo.AdmissionMappingTable.[Admission Type Description] INNER JOIN

dbo.Agency ON dbo.[NMDS Data for IDF Report].[Agency Name] = dbo.Agency.Agengy INNER JOIN

dbo.DHBMappingTable ON dbo.DomicileCodes.[DHB area] = dbo.DHBMappingTable.[DHB Code]

WHERE (dbo.[NMDS Data for IDF Report].[Financial Year] = '20062007')

GROUP BY dbo.DHBMappingTable.[DHB Name], dbo.Agency.DHB_service, dbo.PurchaseUnitMappingTable.PU, dbo.AdmissionMappingTable.Admission

HAVING (dbo.Agency.DHB_service = @dhb_service) and

AND (dbo.DHBMappingTable.[DHB Name] = @dhbname )



The values of " @dhb_service" and "@dhbname" need to be entered when the stored procedure is executed. Now when I execute the stored procedure through the following statement:



exec enterdhbnameDhbService

@dhb_service = 'canterbury' ,@dhbname = 'south canterbury'

SQL does not give me any results, only empty table gets displayed. I have checked the combination.. This combination does exist in my table





pls help guys