Hi,

I have a sp with about 6 if statements and each one has the same where condition such as the following:
if @param=1
begin
select country
from countries
where lang=@lang
end
if @param=2
begin
select name
from customers
where lang=@lang
end

Is it possible to write a query without having to repeat the where condition each time but only once?

Thanks

You may consider using case as the examples from books online

Jaime E. Maccou

If I understand your question correctly, i don't believe it can be done in a SP.
However [As you probably realise] you could dynamically build the query in the application.

Example in VB:

Dim sSQL as String, sWhere as string

sWhere = "where lang=@lang"

sSQL = "if @param=1 begin select country from countries " & sWhere & " end if @param=2 begin select name from customers " & sWhere 'etc etc

you can use this query in stored procedure

declare @str varchar(1000)
declare @where varchar(100)
select @where='where lang='+@lang
select @str='if @param=1 begin select country from countries
             end if @param=2 begin select name from customers
             end ' + @where
execute(@str)