title: use @@SPID in side view defination in sybase ASE15
body: <p>i am not able to use @@spid inside view defination.sybase doesnot allow.
  how can i implement it inside view?. my requirement is: i have one table already existing in production server named MYTABLE. which have only one record at .so any select query form this table will give same output. now i  want to create a table based on ip address corresponding value will be defines. and want to drop table MYTABLE and create a VIEW with the same name
  where it will use ip address to show corresponding output to based on ip address.
  can anybody have idea?</p>