SELECT csm.fkJobID,
             csm.csmContainerID,
             csm.fkSegmentID,
             csm.csmContainerType,
             csm.csmContainerLevel,
             csm.csmDisplayContainerID,
             csm.csmContainerDestinationZip,
             csm.csmContainerGroupingDescription,
             csm.csmEntryPointActualOrDeliveryLocaleKey,
             csmEntryPointforEntryDiscountFacilityType,
             csmActualinductionDate,
             csmActualInductionTime,
             csmScheduledInductionDate,
             csmScheduledInductionTime,
             csmScheduledInHomeDate,
             csm.csmParentContainerReferenceID
      FROM   ContainerSummaryRecord csm
      WHERE  ( csm.fkJobID = @fkMAJobID )
             AND ( csm.csmIsDeleted = 0 )
             AND csmContainerType IN ( 'O', 'T', 'E', 'F',
                                       'S', '1', '2', '3' )
             AND ( csmParentContainerReferenceID IS NULL
                    OR csmParentContainerReferenceID = '' )
             AND ( csm.csmCSMRecordStatus NOT LIKE 'D' )
      ORDER  BY ( CASE
                    WHEN( @ContainerDestinationZip = 1 ) THEN csm.csmContainerDestinationZip
                  END ),
                ( CASE
                    WHEN( @LocaleKey = 1 ) THEN csm.csmEntryPointActualOrDeliveryLocaleKey
                  END ),
                ( CASE
                    WHEN( @InHomeDate = 1 ) THEN csm.csmScheduledInHomeDate
                  END ),
                ( CASE
                    WHEN( @InductionDate = 1 ) THEN csm.csmScheduledInductionDate
                  END ),
                ( CASE
                    WHEN( @InductionTime = 1 ) THEN csm.csmScheduledInductionTime
                  END ),
                ( CASE
                    WHEN( @FacilityType = 1 ) THEN csm.csmEntryPointforEntryDiscountFacilityType
                  END ),
                ( CASE
                    WHEN( @SortLevel = 1 ) THEN csm.csmContainerLevel
                  END ),
                ( CASE
                    WHEN( @CGD = 1 ) THEN csm.csmContainerGroupingDescription
                  END );

ORDER  BY CASE
                    WHEN( @ContainerDestinationZip = 1 ) THEN csm.csmContainerDestinationZip
WHEN( @LocaleKey = 1 ) THEN csm.csmEntryPointActualOrDeliveryLocaleKey

WHEN( @InHomeDate = 1 ) THEN csm.csmScheduledInHomeDate
...
END