USP_SIMPLEDATALIST_SALESMETHODMARKETINGSURVEYQUESTION

            CREATE procedure dbo.USP_SIMPLEDATALIST_SALESMETHODMARKETINGSURVEYQUESTION
            (
                @SALESORDERID uniqueidentifier
            )
            as
                declare @SALESMETHODID uniqueidentifier
                select @SALESMETHODID = SM.ID
                from dbo.SALESMETHOD SM
                inner join dbo.SALESORDER SO on SM.TYPECODE = SO.SALESMETHODTYPECODE
                where SO.ID = @SALESORDERID

                select 
                    MSQ.ID as VALUE, 
                    MSQ.QUESTIONTEXT as LABEL
                from dbo.MARKETINGSURVEYQUESTION MSQ
                inner join dbo.SALESMETHODMARKETINGSURVEYCONFIGURATION SMMSC on SMMSC.MARKETINGSURVEYQUESTIONID = MSQ.ID
                where SMMSC.ISACTIVE = 1
                and SMMSC.SALESMETHODID = @SALESMETHODID
                order by QUESTIONTEXT