解决办法:创建存储过程
CREATE PROCEDURE GL_SP_GetAllTrade
AS
SET NOCOUNT ON
CREATE TABLE #Trade(iTrade_ID int ,cTrade_Name nvarchar(60),iOrder int
IDENTITY(1,1))
INSERT INTO #Trade(iTrade_ID,cTrade_Name)
SELECT EnumIndex,EnumName from v_AA_enum where EnumType='Admin.Trade' AND
EnumIndex=36 order by EnumIndex
INSERT INTO #Trade(iTrade_ID,cTrade_Name)
SELECT EnumIndex,EnumName from v_AA_enum where EnumType='Admin.Trade' AND
EnumIndex=38 order by EnumIndex
INSERT INTO #Trade(iTrade_ID,cTrade_Name)
SELECT EnumIndex,EnumName from v_AA_enum where EnumType='Admin.Trade' AND
EnumIndex=37 order by EnumIndex
--38以后的
INSERT INTO #Trade(iTrade_ID,cTrade_Name)
SELECT EnumIndex,EnumName from v_AA_enum where EnumType='Admin.Trade' AND
EnumIndex>38 order by EnumIndex
INSERT INTO #Trade(iTrade_ID,cTrade_Name)
SELECT EnumIndex,EnumName from v_AA_enum where EnumType='Admin.Trade' AND
EnumIndex<36 order by EnumIndex
SELECT * FROM #Trade ORDER BY iOrder
SET NOCOUNT OFF
GO