> Applications have different purpose,only some tables are in common,

> but not those with year and month,app A has some main tables(fields :

> ...,month,year.) and app B other(fields : ...,month,year.).So only a part

> of structure is the same(month,year),and I decided to use a single SP

> for both.

I would suggest that it is probably better to have different stored
procedures for each app. Requiring that your application logic knows the
name of the tables that physically contain the data seems to defeat the
purpose of using a sproc in the first place...



Dean.



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