Hi,

You need to make sure you are returning something in your stored procedure.
Please see the following link for an example, under "Single Result Set".


SELECT IdTable.ID ,
   ISNULL(SUM(DATEDIFF(DAY, ReportedDate ,CompletedDate)),0) AS DateDifference
FROM dbo.IDTable IdTable
    LEFT JOIN dbo.ReportTable diff ON diff.ID = IdTable.ID
GROUP BY IdTable.ID


Hi,

You can have a look at the following links:

https://technet.microsoft.com/en-us/library/ms175528(v=sql.105).aspx

http://www.sqlskills.com/blogs/kimberly/prepared-statements-and-caching/

I hope these help.

What I'd like to know is how did it get this way? This is a desktop computer which I do regularly turn off to open it up and blow out...

You can check that the SQL Server service is running in SQL Server Configuration Manager.