USP_SIMPLEDATALIST_FUZZYDATE

This simple list contains the system-defined fuzzy dates.

Parameters

Parameter	Parameter Type	Mode	Description
@DATETYPECODE	tinyint	IN	Type of fuzzy date to include

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_FUZZYDATE (@DATETYPECODE tinyint = null) as
    set nocount on;
    select 
        ID as VALUE, 
        NAME as LABEL
    from dbo.FUZZYDATE
    where DATETYPECODE & @DATETYPECODE = DATETYPECODE
    order by DATETYPECODE ASC, SEQUENCE ASC