is it possible to reference a value in a where clause?
select * from staff where salary > 5000;
'staff' is a view and depending on the comparison value (here 5000) which is placed in the above select statement I would need to calculate another value. At the moment I solved the problem by an additional field which gets filled from an extra table which has to be updated with an extra job regularly.
It is important that the 'users' can work with normal SQL syntax, having them to add function calls or something like this is not an option.
Can you elaborate a bit further on your question, what other tabel are you referring to, what other field has to be calulated. Perhaps you can provide an example. I don't understand what the problem is.
With kind regards . . . . . SQL Server 2000/2005/2012
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2. Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages