I've tried.... one thing there are not 2 different databases,is one database and I can't create 2 views with the same name.

sasha <selectnull@...> wrote: >

> The same database is used by 2 distinct application that have
> only some tables in common.So,in aplication 1 user must
> select from a combo year and month and the same thing in
> application 2 but from other table.So I use one SP for both.
>

Ok, I'll give you another idea but it's only an idea and if your solution
works better for you, no harm done.
Since you have different database structures you still might use a view:
In db1:
create view monthyear as select distinct month, year from table_in_db1
In db2:
create view monthyear as select distinct month, year from table_in_db2

That way from both applications you fill your combo with values the same
way, select month, year from monthview;

Sasha






---------------------------------
Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.

[Non-text portions of this message have been removed]