Código SQL:
Ver originalIF OBJECT_ID('tempdb..#temp') IS NOT NULL DROP TABLE #temp
IF OBJECT_ID('tempdb..#ordenada') IS NOT NULL DROP TABLE #ordenada
CREATE TABLE #temp
(
valor VARCHAR(20)
)
INSERT INTO #temp VALUES ('4')
INSERT INTO #temp VALUES ('2')
INSERT INTO #temp VALUES ('3')
INSERT INTO #temp VALUES ('1')
INSERT INTO #temp VALUES ('A1')
INSERT INTO #temp VALUES ('A2')
INSERT INTO #temp VALUES ('5')
INSERT INTO #temp VALUES ('6')
INSERT INTO #temp VALUES ('A3')
INSERT INTO #temp VALUES ('B1')
INSERT INTO #temp VALUES ('7')
INSERT INTO #temp VALUES ('10')
INSERT INTO #temp VALUES ('100')
INSERT INTO #temp VALUES ('20')
INSERT INTO #temp VALUES ('ABC10')
INSERT INTO #temp VALUES ('ABC01')
DROP TABLE #ordenada
CREATE TABLE #ordenada
(
orden INT IDENTITY(1,1),
campo VARCHAR(20)
)
INSERT INTO #ordenada
SELECT * FROM(
SELECT CASE WHEN isnumeric(valor)=1 THEN CONVERT(INT,valor) END campo FROM #temp
) AS t1 WHERE campo IS NOT NULL
ORDER BY campo ASC
INSERT INTO #ordenada
SELECT * FROM(
SELECT CASE WHEN isnumeric(valor)=0 THEN valor END campo FROM #temp
) AS t1 WHERE campo IS NOT NULL
SELECT campo FROM #ordenada
saludos!