emma oj

emma oj

  • 1.2k
  • 195
  • 23.8k

Distinct statement not removing duplicate rows in stored procedure

Jun 27 2021 9:32 AM

My stored procedure does not work once I add distinct to the select statement. It displays no data available in C# gridview.

This is my stored procedure:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOALTER PROCEDURE [dbo].[die2]@PageIndex INT = 1,@PageSize INT = 15,@RecordCount INT OUTPUT
AS
BEGINSET NOCOUNT ON;SELECT DISTINCTROW_NUMBER() OVER (ORDER BY d.[id] ASC) AS RowNumber,d.[dieno],d.[templateno],d.[model],d.[type],d.[comment],d.[lmacross], d.[lmaround],j.[pid], j.[description], o.[supplier],s.[no],o.[deliverydate], o.[orderid], o.[waybillno]INTO #ResultsFROM[job_die] d INNER JOIN stock s ON d.id = s.typeid   INNER JOIN orders o ON s.orderid = o.orderid  INNER JOIN job j ON j.diereferneceno = d.id WHEREo.producttype = '4' AND s.active = '1' SELECT @RecordCount = COUNT(*)FROM #ResultsSELECT * FROM #ResultsWHERE RowNumber BETWEEN (@PageIndex-1)*@PageSize + 1 AND (((@PageIndex-1)*@PageSize + 1) + @PageSize)-1 OR @PageIndex = -1DROP TABLE #Results
END

Please help

sql-server


Answers (1)