Description
Store Procedure for Survey Review
Query :
Store Procedure for Survey Review
Query :
declare @StartDate NVARCHAR(50) = '2025-05-01 06:00:00.000' , @EndDate NVARCHAR(50) = '2025-05-14 18:00:00.000', @OrderColumn NVARCHAR(50) = 'SurveyId', @Order VARCHAR(50) = 'DESC', @start int = 0, @limit INT = 0, @OrderClause NVARCHAR(MAX)= ' order by SurveyId DESC', @CustomClause NVARCHAR(MAX)= N'', @EmailClause NVARCHAR(MAX)= N'', @IsEmailtypeClause bit= 0, @UserClientId Int = 221, @SubClientIds NVARCHAR(50) = '' exec GETSurveyList @StartDate ,@EndDate ,@OrderColumn ,@Order ,@start ,@limit ,@OrderClause ,@CustomClause ,@EmailClause ,@IsEmailtypeClause ,@UserClientId ,@SubClientIds --------------------------------------------------