neda555
دوشنبه 16 آذر 1394, 14:38 عصر
سلام دوستان مشکل این کیوئری اینه که لینکش مشکل داره همه میره به لینک ShowDetailsPages
چه طور تغییرش بدم که این مشکل حل بشه؟
ALTER PROCEDURE [dbo].[SPSelectMaxVisited]
AS
select Top(10) * from(
select ID,Title as title,Description as descriptions,Picture as picname ,'/ShowDetailsPages' as pgLink ,Visited as visited from CSubPage
UNION ALL
select ID,Title as title,Description as descriptions,Picture as picname ,'/DetailsProject' as pgLink ,Visited as visited from CProject
UNION ALL
select ID,Title as title,Description as descriptions,Picture as picname ,'/DetailsNews' as pgLink,Visited as visited from CNews
)as a
ORDER BY a.Visited DESC
چه طور تغییرش بدم که این مشکل حل بشه؟
ALTER PROCEDURE [dbo].[SPSelectMaxVisited]
AS
select Top(10) * from(
select ID,Title as title,Description as descriptions,Picture as picname ,'/ShowDetailsPages' as pgLink ,Visited as visited from CSubPage
UNION ALL
select ID,Title as title,Description as descriptions,Picture as picname ,'/DetailsProject' as pgLink ,Visited as visited from CProject
UNION ALL
select ID,Title as title,Description as descriptions,Picture as picname ,'/DetailsNews' as pgLink,Visited as visited from CNews
)as a
ORDER BY a.Visited DESC