Question

  Asked: May 20 2008   2:02 AM GMT
  Asked by: DanM

Return zero when there's no data

I am trying to write a query that I can use to generate an Excel chart to show activity in our database. I have it returning rows for each minute over the previous two hours (no problem). The problem comes when I plot a line chart. If there's no activity in a given minute, there's no row returned, which causes a break in the series on the chart.
How can I write the query to return zero for minutes where there is no activity?

 RATE THIS ANSWER
-1
Click to Vote:

•   0
•  -1

 SELECT ISNULL(MYFIELD,0)  AS MYVALUE FROM MY TABLE