hello sir
i need to fetch random sql row select in pagainantion
i have used order by newid() but it not working
ALTER PROCEDURE [GetCustomersPageWise]
@PageIndex INT = 1
,@PageSize INT = 7
,@PageCount INT OUTPUT
AS
BEGIN
SET NOCOUNT ON;
SELECT ROW_NUMBER() OVER
(
ORDER BY [PostId] ASC
)AS RowNumber
,[PostId]
,[Title]
,[Descriptions]
,[Url]
,[UploadDate]
,[Duration]
,[Host]
,[ClusterId]
,[ClusterName]
,[LoginId]
,[CreatedDate]
,[ImgPoster]
,[NavigationUrl]
INTO #Results
FROM [PostTbl] order by newid();
DECLARE @RecordCount INT;
SELECT @RecordCount = COUNT(*) FROM #Results
SET @PageCount = CEILING(CAST(@RecordCount AS DECIMAL(10, 2)) / CAST(@PageSize AS DECIMAL(10, 2)))
PRINT @PageCount
SELECT * FROM #Results
WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1 order by newid();
DROP TABLE #Results
END