exec Store Procedure in condition

Question

Hi I have returned one storeprocesered that give me the number of recored with multiple coloum. now i want to check thew records for null if it is null then it will neglect else it show can any one help me for same

chetan shinde · Answer

No Not In this way ...

Upendra Pratap Shahi · Answer

http://www.codeproject.com/Articles/13555/Setting-up-Stored-Procedures-with-Optional-Paramet Select firstnamelastname from [your_tablename] where firstname IS NOT NULL try this type code . If help mark as This is correct answer

chetan shinde · Answer

yeah but i dont want to edit the store procedure. i want to edit in when we write exec Storeprocname (parameters). is there any way to check ... like we write isnull in start or check for value 0 in exec statement

Syed Shanu · Answer

In that case you can check in where condition for example Select firstnamelastname from your tablename where firstname IS NOT NULL hope this will help you.

chetan shinde · Answer

Yeah Right.....

Syed Shanu · Answer

Do you mean you dont want to show null row for certain Column.for example you have FirstName and Lastname as columns and if there is any null in firstname then dont need to show that row ?