Hi
I want to compare values of two fields in same resultset. Like I have resultset whrre there are two fields Frequency and New_Frequency I want to compare this two like if
Frequency = New_Frequency then do some logic.
I tried with derived columun using Frequency == New_NewFrequency but it doesn't work.
Let me know is there any way to compare?
Dnyandeo
for derived column use in such a way
a = case when frequency = new_frequency then
begin
some logic
end
else
some logic
end
end
or can u send me the script code that u had used for derived column?
