Hi All.
I have problem to fix a view in MS SQL. It looks like:

SELECT Date_P, -SUM(is not null [Result]) AS Complete,
-SUM(is null [Result]) AS [Not Complete]
FROM dbo.Prob
GROUP BY Date_P

Message says: "Incorrect syntax near the keyword 'is'." How resolve that problem?
Thanks.

Try:

SELECT Date_P, -SUM(Not IsNUll([Result])) AS Complete,
-SUM(isnull([Result])) AS [Not Complete]
FROM dbo.Prob
GROUP BY Date_P