Select gif_GameInfoID as t2_GameInfoId,
gif_GameInfoName as t2_Name,
cast(0 as int) as t2_WinCredits,
cast(0 as int) as t2_LostCredits,
cast(0 as int) as t2_CountCredits,
cast(null as datetime) as t2_TimeStamp
Into #Temp_Return
From vw_GameInfo inner join vw_GameCreditHistory on gif_GameInfoId=gch_GameInfoId
Where gch_UserCode=@UserCode
group by gif_GameInfoId,gif_GameInfoName我想在后面加个排序条件要怎么加啊,加上去好像有问题,怎么搞
Order By @OrderWay Desc
gif_GameInfoName as t2_Name,
cast(0 as int) as t2_WinCredits,
cast(0 as int) as t2_LostCredits,
cast(0 as int) as t2_CountCredits,
cast(null as datetime) as t2_TimeStamp
Into #Temp_Return
From vw_GameInfo inner join vw_GameCreditHistory on gif_GameInfoId=gch_GameInfoId
Where gch_UserCode=@UserCode
group by gif_GameInfoId,gif_GameInfoName我想在后面加个排序条件要怎么加啊,加上去好像有问题,怎么搞
Order By @OrderWay Desc
gif_GameInfoName as t2_Name,
cast(0 as int) as t2_WinCredits,
cast(0 as int) as t2_LostCredits,
cast(0 as int) as t2_CountCredits,
cast(null as datetime) as t2_TimeStamp
Into #Temp_Return
From vw_GameInfo inner join vw_GameCreditHistory on gif_GameInfoId=gch_GameInfoId
Where gch_UserCode=@UserCode
group by gif_GameInfoId,gif_GameInfoName
Order By {0} Desc", OrderWay);