Santosh Sasupalli

Santosh Sasupalli

  • 1.4k
  • 181
  • 22.9k

stored procedure for filters

Aug 31 2016 6:59 AM
i have a task
@state varchar(50),
@location varchar(50)
as
begin
end
if he pass state="",location="" then select all institutes in country
if he pass state value then select  institutes in that state
if he pass location also value then select institutes in that particular location
 
how to write query 
please help me
 
 

Answers (4)