i'm using the following sp.
ALTER procedure [dbo].[GET_ORGRESOURCE]
select * from Resources where ORGANIZATION<>@ORGID and ORGANIZATION=NULL
there r some rows with NULL value in the table Resources.but the above sp is displaying empty table.if ORGANIZATION=NULL condition is removed then it's displaying table except the rows which have null value for ORGANIZATION column.
can any one help me to get the rows with null values also?
View Complete Post