Database

// Since you said C#
from oh in context.Order_History
where oh.OrderDate ...

orderby oh.OrderNumber desc
group oh by oh.RequiredProperty in ohGrouped // RequireProperty is the property you want to use

... 
select ...

CASE

If code >= 1 AND <= 9 then place two zeros if front...001, 002....009
if code >= 10 AND <= 99 then place one zero if front....010, 050...,099

FORMAT(code, 'D3')

CASE
    WHEN code Between 1 And 9 THEN '00'
    WHEN code Between 10 And 99 THEN '0'
    ELSE ''
END + CAST(code As varchar(10))

SELECT Right('00' + Convert(Varchar(10),[code]),2) as [Code]

WITH cte (code) As
(
    SELECT 1
    UNION ALL SELECT 10
    UNION ALL SELECT 100
    UNION ALL SELECT 1000
    UNION ALL SELECT 10000
)
SELECT
    code,
    RIGHT('00' + CONVERT(varchar(10), code), 3)
FROM
    cte
;

1       001
10      010
100     100
1000    000
10000   000

SELECT Format([Code],'000') as [Code] 

Chris Quinn wrote:

There is, of course another way:

SELECT RIGHT(REPLICATE(0,2)+CAST([EMPLOYEE].JOB_CODE AS NVARCHAR(200)),3) FROM YourTable

FOR Pay_ClassHrs in (PBS_Hrs,  POT_Hrs, PED_Hrs, POR_Hrs, PJB_Hrs, PTO_Hrs, PWH_Hrs, PHR_Hrs, PNH_Hrs)

case when PBS_Hrs IS NULL then 0 end

FOR Pay_ClassHrs in (ISNULL(PBS_Hrs, 0), POT_Hrs, PED_Hrs, POR_Hrs, PJB_Hrs, PTO_Hrs, PWH_Hrs, PHR_Hrs, PNH_Hrs)

mbb01 wrote:

Apart from those of us who are hopelessly OCD about these sort of things

mbb01 wrote:

I'm more interested in the reasons why it should be done at all.

mbb01 wrote:

After a debate about how it could be done and whether it should be done, I was struck by my colleague's statement of 'a lot of effort and potential pain, for not much gain'. There is of course the obvious risk of removing a table that really is used and causing a live system to fail.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

mbb01 wrote:

are there any good reasons for running the risk of removing defunct tables from a live system?

mbb01 wrote:

Apart from those of us who are hopelessly OCD about these sort of things