RE:iff o case en la clausula where
con sql dinámico, ejemplo:
select @select_reg = case @reg
when 1 then
\'select * from #reg , temp_registro_documental \'
when 0 then
\'select * from #reg \'
end
--return
select @where_reg = case @reg
when 1 then
\' where temp_registro_documental.id_usuario = \' + convert(varchar(255),@usu) + \' and #reg.clave2 = temp_registro_documental.clave22\' when 0 then
\' \'
end
--return
--select @select_reg + \' \' + @where_reg as cadena_sql
exec( @select_reg + \' \' + @where_reg)