April 6, 2009 at 9:06 am
shnex (4/6/2009)
HiI have a database that uses and stores information related to other database.
What is the use of this database??? are you using this database to query new database? what is the relationship between this database and new database. could you please put some more information aroud you requirement.
April 6, 2009 at 9:24 am
So
The initial database was prety big. It contained persons and information for this persons.
In 2 tables we had lots of information, so these two tables and the sp that use them were stored in a new one.
Now there is another database with persons, for wich the informations will be stored in the same new database(the one with 2 tables).And I have to modify the sp to work with data from a specific database.I added as a input parameter the name of the database.
First, when it was only the person and the info database, I created views that referenced the tables I need about the persons.I don't think that creating another set of views will be the solution.I want to have the same sp no matter what is the database,and I think that using a parameter, as a flag, is enough, but I don't know how ti restructure the sp.To use dinamic queries or static.I don't want to use dinamic because the sp's are prety slow, and they will be slower.I hope this is more clear....:D
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply