Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Saturday, August 26, 2017

Nested sub queries with SUM, optional parameters in Storedprocedure

SQLServerCentral » Latest topics
Nested sub queries with SUM, optional parameters in Storedprocedure
Hi,
The following storedprocedure (seems) to work fine when I supply all the optional parameters.
But if I leave out (ie don't supply a value) the parameter @IDAfd for example, no records are returned.

No comments: