Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Stored Procedure

Author  Topic 

flextera
Yak Posting Veteran

50 Posts

Posted - 2014-10-16 : 12:48:23
I have a stored procedure that I am running in SSMS 2012.

When it comes to a row that has nothing in it, it doesn't show the row at all.

I WANT it to say ZERO instead of not showing the row completely.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-10-16 : 12:50:37
quote:
Originally posted by flextera

I have a stored procedure that I am running in SSMS 2012.

When it comes to a row that has nothing in it, it doesn't show the row at all.

I WANT it to say ZERO instead of not showing the row completely.

You will need to open up the code for the stored procedure and make the required changes. Without seeing the code, it is not possible to suggest what kind of changes are required.
Go to Top of Page
   

- Advertisement -