DECLARE @NoClient Int DECLARE @Tax Float DECLARE @NoStatus Int DECLARE @NoStatus2 Int DECLARE @AddDate DateTime SET @NoClient=2087603 SET @Tax=1 SET @NoStatus=7 SET @NoStatus2=8 SET @AddDate='2014-10-01 15:29:59' SELECT Invoice.Numero FROM Invoice (NOLOCK) WHERE Invoice.NoClient=@NoClient AND Invoice.Tax=@Tax AND Invoice.NoStatus<>@NoStatus AND Invoice.NoStatus<>@NoStatus2 AND Invoice.AddDate>@AddDateFrom IIS and ASP.NET, this returns 0 record. From SSMS, it returns 1 record.