Hi
I'm trying to pass parameters from VB to a stored procedure.  Depending on
which record is chosen the stored procedure can either execute a View or
another Stored Procedure.  Below is a sample of the main (Parent) SP.  For
some reason when I pass all three parameters I don't get anything, anyone
know why?

Kind Regards

Rikesh

CREATE  PROCEDURE GetCriteria

AS

                BEGIN
                    BEGIN


                    END

                END

ELSE
                BEGIN
                    BEGIN


                    END

                END

Below is the sample code for the qfm_RptGeogTest SP:

CREATE PROCEDURE qfm_RptGeogTest

AS

    SELECT  GeographyID,
                    ParentID,
                    Name,
                    Level

    FROM Geography

GO