USP_SIMPLEDATALIST_SMARTFIELDVALUEGROUPITEMS

CREATE procedure dbo.USP_SIMPLEDATALIST_SMARTFIELDVALUEGROUPITEMS
(
    @SMARTFIELDID uniqueidentifier
)
as begin
    select 
        SMARTFIELDVALUEGROUP.ID as VALUE, 
        SMARTFIELDVALUEGROUP.GROUPNAME as LABEL 
    from 
        dbo.SMARTFIELDVALUEGROUP
    where
        SMARTFIELDVALUEGROUP.SMARTFIELDID = @SMARTFIELDID
    order by
        SMARTFIELDVALUEGROUP.INTEGERVALUERANGE,
        SMARTFIELDVALUEGROUP.MONEYVALUERANGE,
        SMARTFIELDVALUEGROUP.DATEVALUERANGE
end