USP_DATALIST_RECONCILIATIONCURRENCYLABEL_ALL

        CREATE procedure dbo.USP_DATALIST_RECONCILIATIONCURRENCYLABEL_ALL 
            (
                @LABELTYPE bit
            )
            as

            set nocount on

            declare @LABELTABLE table (
                LABEL nvarchar(10),
                UNIT decimal(5,2),
                LABELTYPE bit -- 0: currency, 1: coin

            );

            insert into @LABELTABLE values 
                ('$1', 1, 0),
                        ('$2', 2, 0),
                ('$5', 5, 0),
                ('$10', 10, 0),
                ('$20', 20, 0),
                ('$50', 50, 0),
                ('$100', 100, 0),
                ('1?', .01, 1),
                ('5?', .05, 1),
                ('10?', .1, 1),
                ('25?', .25, 1),
                ('50?', .50, 1),
                ('$1', 1, 1);

            select LABEL, UNIT
                from @LABELTABLE 
                where LABELTYPE = @LABELTYPE
                        order by UNIT desc;

          return;