-
- DECLARE @StartDate DATE='2019-06-01'
- DECLARE @EndDate DATE='2019-06-30'
- DECLARE @AllEmpIds NVARCHAR(MAX)='2001,2005,2011,2031,2118,2030,2032'
- SELECT TOP 1 ISNULL(SUM(R.fldRowTotal),0) AS totalServiceSaleBasedPrice,R.fldEmployeeId FROM TblTicketsSummary S
- JOIN TblTicketsRow R ON S.fldTicketID = R.fldTicketID WHERE S.fldTicketStatus = 'Closed' and S.fldClientID IS NOT NULL
- AND CONVERT(VARCHAR(10), S.fldDateClosed, 120) >= CONVERT(VARCHAR(10), @StartDate, 120) AND
- CONVERT(VARCHAR(10), S.fldDateClosed, 120) <= CONVERT(VARCHAR(10), @EndDate, 120) AND R.fldPS IN ('S','M') AND
- CAST(R.fldEmployeeId AS NVARCHAR(50)) IN (@AllEmpIds) GROUP BY R.fldEmployeeId
- ORDER BY totalServiceSaleBasedPrice DESC
-
-
- SELECT TOP 1 ISNULL(SUM(R.fldRowTotal),0) AS totalServiceSaleBasedPrice,R.fldEmployeeId FROM TblTicketsSummary S
- JOIN TblTicketsRow R ON S.fldTicketID = R.fldTicketID WHERE S.fldTicketStatus = 'Closed' and S.fldClientID IS NOT NULL
- AND CONVERT(VARCHAR(10), S.fldDateClosed, 120) >= CONVERT(VARCHAR(10), '2019-06-01', 120) AND
- CONVERT(VARCHAR(10), S.fldDateClosed, 120) <= CONVERT(VARCHAR(10), '2019-06-30', 120) AND R.fldPS IN('S','M') AND
- CAST(R.fldEmployeeId AS NVARCHAR(50)) IN (2001,2005,2011,2031,2118,2030,2032) GROUP BY R.fldEmployeeId
- ORDER BY totalServiceSaleBasedPrice DESC
When i run query1 it gives no result where as query2 gives some value.
What is wrong in query1?