USP_BATCHNUMBERINGSCHEME_DATEFORMATCODE_GETLIST

Definition

Copy
/*
Generated by Blackbaud AppFx Platform
Date:  11/30/2010 11:16:30 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_BATCHNUMBERINGSCHEME_DATEFORMATCODE_GETLIST
AS
    select 1 'ID', 'MM-DD-YY' 'DESCRIPTION'
    union
    select 2 'ID', 'MM-DD-YYYY' 'DESCRIPTION'
    union
    select 3 'ID', 'MM-YY' 'DESCRIPTION'
    union
    select 4 'ID', 'MM-YYYY' 'DESCRIPTION'
    union
    select 5 'ID', 'DD-MM-YY' 'DESCRIPTION'
    union
    select 6 'ID', 'DD-MM-YYYY' 'DESCRIPTION'
    union
    select 7 'ID', 'MMDDYY' 'DESCRIPTION'
    union
    select 8 'ID', 'MMDDYYYY' 'DESCRIPTION'
    union
    select 9 'ID', 'MMYY' 'DESCRIPTION'
    union
    select 10 'ID', 'MMYYYY' 'DESCRIPTION'
    union
    select 11 'ID', 'DDMMYY' 'DESCRIPTION'
    union
    select 12 'ID', 'DDMMYYYY' 'DESCRIPTION'
    union
    select 13 'ID', 'MM/DD/YY' 'DESCRIPTION'
    union
    select 14 'ID', 'MM/DD/YYYY' 'DESCRIPTION'
    union
    select 15 'ID', 'MM/YY' 'DESCRIPTION'
    union
    select 16 'ID', 'MM/YYYY' 'DESCRIPTION'
    union
    select 17 'ID', 'DD/MM/YY' 'DESCRIPTION'
    union
    select 18 'ID', 'DD/MM/YYYY' 'DESCRIPTION'
    union
    select 19 'ID', 'YY' 'DESCRIPTION'
    union
    select 20 'ID', 'YYYY' 'DESCRIPTION'
    union
    select 21 'ID', 'YYMM' 'DESCRIPTION'
    union
    select 22 'ID', 'YYYYMM' 'DESCRIPTION'
    union
    select 23 'ID', 'YYMMDD' 'DESCRIPTION'
    union
    select 24 'ID', 'YYYYMMDD' 'DESCRIPTION'
    union
    select 25 'ID', 'YYDDMM' 'DESCRIPTION'
    union
    select 26 'ID', 'YYYYDDMM' 'DESCRIPTION'
    union
    select 27 'ID', 'YY-MM' 'DESCRIPTION'
    union
    select 28 'ID', 'YYYY-MM' 'DESCRIPTION'
    union
    select 29 'ID', 'YY-MM-DD' 'DESCRIPTION'
    union
    select 30 'ID', 'YYYY-MM-DD' 'DESCRIPTION'
    union
    select 31 'ID', 'YY-DD-MM' 'DESCRIPTION'
    union
    select 32 'ID', 'YYYY-DD-MM' 'DESCRIPTION'
    union
    select 33 'ID', 'YY/MM' 'DESCRIPTION'
    union
    select 34 'ID', 'YYYY/MM' 'DESCRIPTION'
    union
    select 35 'ID', 'YY/MM/DD' 'DESCRIPTION'
    union
    select 36 'ID', 'YYYY/MM/DD' 'DESCRIPTION'
    union
    select 37 'ID', 'YY/DD/MM' 'DESCRIPTION'
    union
    select 38 'ID', 'YYYY/DD/MM' 'DESCRIPTION'