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'