Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005

    Question Unanswered: referencing value in where clause


    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.

    Thanks in advanve for any help!

  2. #2
    Join Date
    Nov 2004
    Provided Answers: 4
    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

  3. #3
    Join Date
    Oct 2005
    I do not understand your problem.

    You have a value, lets say 5000, in your select statement.
    What else exactly you need to calculate with it ?

    If it is a program, how about using a variable (parameter marker, static: host variable) ? That can be re-used.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts