Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
I can't do selects because not all the foreign keys are straightforward. An example, to look up a repair description I use the six digit repair code and go to the repair master file (25,000 rows). However if the description code ends in '99', which means the part is defective and couldn't be repaired, I have to substitute an '01' in place of the '99' before I get the repair description. If I didn't have little quirks like this in the data rules I could build views.
There are a lot of conditions like this in the foreign keys. This is a very old manufacturing system that is running on an AS400 and mirrored to an SQLserver, then I am building a reporting system for management from the mirrored data.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement