hi
this is SP:
ALTER procedure [dbo].[codemelk_ViewInfoM]
@mobile nvarchar(30)
,@Transfer1 nvarchar(20)
,@Transfer2 nvarchar(20)
,@Transfer3 nvarchar(20)
,@Transfer4 nvarchar(20)
,@Transfer5 nvarchar(20)
,@Transfer6 nvarchar(20)
as
begin
select date ,MalekName,MalkeMobile,MosName,MosMobile,code,id,Transfer
from Estate_info
where (MalkeMobile=@mobile )OR (MosMobile=@mobile )and(Transfer=@Transfer1 or Transfer=@Transfer2 or Transfer=@Transfer3 or Transfer=@Transfer4 or Transfer=@Transfer5 or Transfer=@Transfer6)
end
I run SP:
as you see in above image I show with green arrow I type 'sell' for @transfer2 and I expect that it just display second row but as I point with red arrow it show Transfer='apartman' but I want it just show second row with transfer--->"sell"
how I should change SP:
best regards
neda
