UFN_SALESMETHODMARKETINGSURVEYCONFIGURATION_GETMARKETINGSURVEYQUESTIONS

        create function dbo.UFN_SALESMETHODMARKETINGSURVEYCONFIGURATION_GETMARKETINGSURVEYQUESTIONS(@SALESMETHODID uniqueidentifier = null)
        returns table
        return
            select
                MSQ.ID MARKETINGSURVEYQUESTIONID,
                MSQ.QUESTIONTEXT
            from dbo.MARKETINGSURVEYQUESTION MSQ
            inner join dbo.SALESMETHODMARKETINGSURVEYCONFIGURATION SMMSC on MSQ.ID = SMMSC.MARKETINGSURVEYQUESTIONID
            where SMMSC.SALESMETHODID = @SALESMETHODID
            and SMMSC.ISACTIVE = 1