select ROW_NUMBER() OVER (ORDER BY Advertisement.AdsDate asc ) AS AdsIndex ,Advertisement.AdsId , Advertisement.AdsEnTitle from Advertisement where Advertisement.Status=N'True' and AdsIndex<=17 and AdsIndex>=11
Invalid column name 'AdsIndex'.
SELECT AdsIndex, AdsId, AdsEnTitle FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY Advertisement.AdsDate ASC) AS AdsIndex FROM Advertisement) WHERE Status=N'True' AND AdsIndex<=17 AND AdsIndex>=11
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)