i need help in writing query, i have a stored proc..in that i have a variable as int, when i pass '0' to the variable then i want to select all row from table other wise if i have some digit then based on the value i want to get the rows.
i have writtenCREATE procedure [dbo].[admin_SP_ResturantDetails_SelectByUserid]
end and it works when the Uid is greater then 0, now when i pass 0 then i want all the rows from table..i did search and found that i should use 'case' in where clause, but unable to write query.Can anybody guide me??Thanks
View Complete Post