CREATE PROCEDURE selectSongsByDateTemp @Day int, @Month int, @Year int, @fromP int
AS
SELECT TOP 10 * from (
SELECT TOP @fromP HitParad.id,HitParad.Composition, Sum(vote_HitParad.Points) AS [Sum-Points], HitParad.Performer, HitParad.current_date_now, Day(current_date_now) AS Date,
MONTH(current_date_now) AS Month, YEAR(current_date_now)
AS Year
FROM HitParad INNER JOIN vote_HitParad ON HitParad.id = vote_HitParad.id_song AND (Day(vote_HitParad.[Date])<=@Day ) AND (Month(vote_HitParad.[Date])<=@Month ) AND (Year(vote_HitParad.[Date])<=@Year )
GROUP BY HitParad.id,HitParad.Composition, HitParad.Performer, HitParad.current_date_now
order by [Sum-Points] desc ) as S
Выдает ошибку в строке SELECT TOP @fromP ... если @fromP меняю явно на число то все пашет.. В чем проблема ???
