Hi.. I'm trying to add a sproc that I can add in Sql Server, but doesn't work in the DNN SQL tool..

ALTER PROCEDURE {databaseOwner}{objectQualifier}Store_Products_GetDistinctListofMYProducts
        @PortalID int
    AS
   
    SELECT
        DISTINCT MyID,
        ProductID,
        PortalID,
        CategoryID,
        Manufacturer,
        ModelNumber,
        ModelName,
        ProductImage,
        UnitCost,
        Summary,
        Description,
        Featured,
        Archived,
        CreatedByUser,
        CreatedDate,
        ProductWeight,
        ProductHeight,
        ProductLength,
        ProductWidth,
        SaleStartDate,
        SaleEndDate,
        SalePrice

    FROM {databaseOwner}{objectQualifier}Store_Products
    WHERE PortalID = @PortalId
    AND CategoryId in (select CategoryId from store_categories where members = '')
    AND IsDeleted = 0 AND Archived = 0

Any Ideas.. I think it's the DISTINCT thing that is causing the issue in DNN.. I"m using 4.09 if that makes a difference.

Thanks,

Jay