yes Stored proc returns morre than 5000 rows
only checkbox is not getting updated according to result
ALTER PROCEDURE [dbo].[proc_Emp]
-- Add the parameters for the stored procedure here
@Emp varchar(20),
@EmpType varchar(20)
AS
BEGIN
Declare @wherecondition1 varchar(max)
DECLARE @SQL_FULLSELECT_STMT NVARCHAR(MAX)
if @EmpType= 'All'
Begin
SET @wherecondition1 = 'Where Emp Like ' + '''' + '%' + ''''
End
Else
Begin
SET @Emp = REPLACE(@Emp,',', '''' + ',' + '''')
SET @wherecondition1 = ' Where Emp IN (' + '''' + @Emp + '''' + ')) '
End
SET @SQL_FULLSELECT_STMT =
' Select Upper (Emp ' + '+' + '''' + ' ' +'''' + '+' +' EmpName) as Emp' +
' FROM vwCoreEmp ' +
@wherecondition1 +
' order by Emp , Empname '
END
EXECUTE sp_executesql @SQL_FULLSELECT_STMT
