i'm extracting data on sql server 2008 r2
(and using script in microsoft excel
query in end). query has number of where
clauses based on parameters in excel cells
.
however have issue script designing in management studio
want parameter allowed leave blank. though if returns values not nulls
. need along lines:
where .... , nd.title = case when @param1 = 'blank' "return including null" else "return" @param1
but cannot work out how achieve this.
her how can this:
where .... , (nd.title = @param1 or @param1 = '' or @param1 null)
Comments
Post a Comment