I have the following query :
SELECT *
FROM Table1
PIVOT
(
SUM(Value)
FOR [Period] IN ([06/1/2007],[07/1/2007])
)
AS p
Some of the rows returned are null but i want to replace them with 0.
I've tried SUM(ISNULL(Value,0)) as Val
but it's not working. ( it's saying incorrect syntax)